trim?

[dbalargin]

How do I trim the first two letters off of a string in a query?
ex. Iif(isnumeric(fdrid),fdrid,I need the trimed word here)

 

[Mile-O]

Are you trying to get rid of the first two letters or use the first two letters?


To use the first two letters use the Left() function and two exclude the first two letters you can use either the Mid() or Right() functions.

 

[Vassago]

lol, try this:

Iif(isnumeric([fdrid]),[fdrid],right([fdrid]3))

That should work for you.

Vassago

 

[Mile-O]

That should work for you.

It might if you put the comma in too:

Iif(isnumeric([fdrid]),[fdrid],right([fdrid], 3))

 

[Mile-O]

But

IIf(IsNumeric([fdrid]), [fdrid], Mid([fdrid], 3))

would be better as Right would only take the three characters on the right of the string.

 

[Vassago]

Thanks for correcting my comma mistake. Typo

And the three characters to the right is all that he needs. I have strong mental powers to read into his database and see what he's talking about. (Or we may just happen to work at the same place.)