This content has been marked as final. Show 6 replies
I have a field named "Product" that has numbers which start with zeroes that I want to get rid of.
For example, some of the entries in this field are:
I want to get rid of the zeroes and keep only the numbers
and I want to name this new column as "PRODUCT" and I want to do this under a load statement. not in the SQL that extracts this column. I tried a Ltrim but it didnt work
Can someone help me with the code?