Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one Column ContractID..
Values:
000238
000567
000786
001234
001435
028978
I want to remove zeros how can i write in back end scripting..
replace(ltrim(replace(ContractID,'0',' ')),' ','0') as ContractID
This was taken from a previous discussion:
Num(ContractID) as ContractID
replace(ltrim(replace(ContractID,'0',' ')),' ','0') as ContractID
This was taken from a previous discussion:
Hi,
Use like this below :
PurgeChar(ContractID , '0') as NewContractID
OR
num(ContractID ) as NewContractID
Hi,
May be like this.
Regards
ASHFAQ
Hi, try this:
REPLACE(LTRIM(REPLACE(FIELD, '0', ' ')), ' ', '0')as FIELD,
good luck
Fernando
you can use:
num(youFieldName)
it will cut of leading zeros.
regards,
MT
You try this:
Data:
LOAD Values, Num(Values,'0') AS Values_New INLINE [
Values
000238
000567
000786
001234
001435
028978
];
Best Regards.
Tonial.