Using the Instr() function 1

[dgillz]

I am looking for a way to test for the existence of a substring within a string in a MS Access query. In Crystal I could do this as follows:

Instr(Sting,substring)>0

However I am having troubling getting th same info out of Access. Any ideas would be appreciated.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[Golom]

Looks exactly the same in Access

Instr ( "ABCD", "C" ) produces 3

 

[afryer]

Hi,

The method is very similar but the first parameter for INSTR in Access in start, i.e

Instr(1,Sting,substring)>0

would produce the same results.

Andrew

 

[Golom]

afryer
True enough but the first parameter is optional. If it if of numeric type then it is assumed to be the start position. If it is a string then it is assumed to be the string to search. Either construct will work.

 

[afryer]

Thanks, I stand corrected :-D

Andrew

 

[dgillz]

Many thanks, people like you are why I come to tek-tips.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com