Creating a Unique Number with a Prefix

This procedure will allow you to add a code to the number provided by  
@NUMBER.  This example will use @NUMBER to produce a string in the form "PN-" 
followed by four digits (i.e. PN-0026, PN-1097, etc.).




Part Number: <#3: #3 = "PN-" + @RIGHT("0000" + @STR(@NUMBER), 4)




Application:  Product numbers can be generated that are customized to a 
specific organizationŐs style.








































Q & A Application Note       Rev. 6/92           #2112     Page 1 of 1