Update Query and ignore spaces

[Luddite Lad]

I have an update query that creates a reference.

part of the update is the following code

(Left([clientname],Len([clientname])-(Len([clientname])-3)))

Which works fine. What I'm wondering is if there is a way to ignore any spaces that might be in the first three characters. So in other words simply pick up the first three alpha numerics?

 

[doco]

Try clientname = Replace( clientname, " ", "" )

Then Left( clientname, 3 )

 

[Luddite Lad]

Just what I was looking for, thanks

I used

(Left(Replace([clientname]," ",""),3))

 

[doco]

Just what I was looking for, thanks

I used

(Left(Replace([clientname]," ",""),3))

Yup - that'll work

Glade to be of service