Recognize a character in a string.

[Manny]

Hi there,

Is it possible to be able to recognize a single character in a string?

for example is the following string: KNBVGFHRUY

I want to identify if in the string there is K or Y or V

Any help would be appreciated.

Thanks in advance

Manny

 

[RobFMS]

Ok...I pulled this straight from the help file to give you some insight on
the Instr() function.
This works on the FIRST occurrence. So, at minimum, you will know if the
character exists.

This example uses the InStr function to return the position of the first
occurrence of one string within another.

Dim SearchString, SearchChar, MyPos
SearchString ="XXpXXpXXPXXP" ' String to search in.
SearchChar = "P" ' Search for "P".

' A textual comparison starting at position 4. Returns 6.
MyPos = Instr(4, SearchString, SearchChar, 1)

' A binary comparison starting at position 1. Returns 9.
MyPos = Instr(1, SearchString, SearchChar, 0)

' Comparison is binary by default (last argument is omitted).
MyPos = Instr(SearchString, SearchChar) ' Returns 9.

MyPos = Instr(1, SearchString, "W") ' Returns 0.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-