trim

[tlee898]

I have a column with the following information. 09898997654. I want to trim the leading zero off and only have the remain info. Does somebody know the formula that will give me that in a query.

thanks in advance.

 

[giacomo]

if you're looking to change the data from text to a number you can use the cdbl function CDBL([data_field]), if you want to keep the data as text then you can use the right function RIGHT([data_field], LEN([data_field])-1)

I have a column with the following information. 09898997654. I want to trim the leading zero off and only have the remain info. Does somebody know the formula that will give me that in a query.

thanks in advance.