Feb 4, 2002 #1 ruimgp IS-IT--Management Feb 4, 2002 10 PT Hi I want to select trim or lpad some values of integer type I do select trim(field) or select lpad(field, 10, " " and i come up an error. Can somebody hep me with this sintax? thank u
Hi I want to select trim or lpad some values of integer type I do select trim(field) or select lpad(field, 10, " " and i come up an error. Can somebody hep me with this sintax? thank u
Feb 4, 2002 #2 kenred Technical User Aug 16, 2001 58 GB Not sure but I think clip(field) might do it, apologies if wrong Upvote 0 Downvote