How do I translate numbers like 1 into 000000001 and so on? I need the in order to print product codes....
Look up the LPAD function or RPAD depending on what you are trying to do. You may find that you need to change the datatype of the database field to a varchar though.
Thanks Again, James. <BR>I dont know what us, newbies, would do without you frequent help.<BR>Keep the good work.<BR>Hope someday we can help you too :)<BR>