Stephen Russell wrote: > > Let me get this straight you have the int value and you want to pad > "0000" to it. > > You could make a computed column for the table that does this for you. :) > > I have a column num and adding Charnum computed column
Naw, I had a 10 char field that was just added to an existing table, and needed to be filled one time with values for existing records. On a go forward basis, there's already code in place to generate new numbers as records are added. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
