Remove spaces

[deejay_totoro]

Hello all,

I have a field that contains number data. I need to remove the preceeding spaces from this field in my query.

How can I do this?

for example:

fldHouseNumber: " 1"
should be
fldHouseNumber: "1"

I have searched through forum and found some complicated solutions. However I am sure I remember using a more simple solution in the past.

Many thanks,

dj_T

ps: this is my 50th post! thanks to everyone for their help so far.

 

[Mile-O]

Trim(MyField)

 

[Mile-O]

ps: this is my 50th post

It says 101 under your name.

 

[deejay_totoro]

101!

wow!

thats cool

thanks again!