I need to find the next Id to be used in an order and pad a 0 to the front..
I know that I can select the max(strIid)+1 and get the next orderid. How do I use the Replicate function to add a leading zero to the id which is a varchar(5)?
Results 1 to 2 of 2
Thread: ReplicateThreaded View
|
|
|