want to know how to chop the last 3 characters of a string

[lennyBaby]

I am new to VB and want to know how to chop the last three characters off a string. Am writing dynamic SQL and have to take the AND off the last WHERE clause if needed.

Any help greatly appreciated

 

[Mile-O]

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

 

[raskew]

"Der Worte sind genug gewechselt, lasst mich auch endlich Taten sehn!"

= I'm eleven years old, my sister's husband diddled me and now I'm pregnant.

Love those foreign language quotes! Nice touch!

 

[lennyBaby]

Thanks dude

 

[gmmccarthy]

I don't think so

This is the translation literally - Of the words are changed enough, leave me also, finally, to actions sees!

Would probably be worded differently in English conversation.

What threw me off was that the word eleven given in your translation was not in the quote. The german word for eleven is elf.

 

[raskew]

Actually I was zehn when it occurred. I'm now elf, but I'll be zwolf on my baby's first birthday.