Grabbing certain number of Characters from Strings (Access 2000)

[PlylerMD]

I need to be able to determine if the last 7 characters of a string is equal to " WHERE ". How do I do this?

Mike

[LegareColeman]

<code>
If Right(strMyString,7) = "Where" Then
</code>

[HansV]

You can use Right(expression,7) to return the last 7 characters of expression

If you tell us how you want to use this, we may be able to offer more specific help.

[PlylerMD]

that is exactly what I wanted. I am just using this to determine what comes next in an SQL statement. The only question I have would be will this function pick up the spaces in " WHERE " before and after the word?

Thanks

[LegareColeman]

Yes, as Hans and I wrote it, it will pick up the last seven characters whatever they are. If you don't want the trailing space, then you could use something like:

<code>
Right(Trim(strMyString),7)
</code>

[PlylerMD]

That worked great.

Thanks