View Single Post
  #1 (permalink)  
Old 09-02-2006, 11:10 PM
colleen1980@gmail.com
Guest
 
Posts: n/a
Default Insert zero before number(as a first character) of type text

Hi:
Is there any way by which i insert 0 before the value by query. I have
a table contains 10,000 records and because of some reason i need to
move 0 before number of field Tech_ID. Type of field is Text.

Thank You.

Reply With Quote