Feb 4, 2002 #1 ruimgp IS-IT--Management Joined Feb 4, 2002 Messages 10 Location 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 Joined Aug 16, 2001 Messages 58 Location GB Not sure but I think clip(field) might do it, apologies if wrong Upvote 0 Downvote