You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Instr function in SQR

2 replies [Last post]
Guest's picture

Can anybody tell me what does INSTR function does in SQR?

maheshkundu's picture
User offline. Last seen 10 years 40 weeks ago. Offline
Joined: 05/16/2008
Posts: 12
Re: Instr function in SQR

Hi friend,
this function returns the numeric position of the specified sub-string within a string.the search begins at the specified position(starting from 1)within the string.

First Argument:a date/string literal,column,variable/expression
second argument:a date/string literal,column,variable/expression
specifying the searched sub-string.

third argument: an integer,column,variable/expression specifying the
starting position.

returns : A float numeric...

U can give me ur mail id.i've one sqr pdf.
everything abt sqr u'll get into that pdf...okkk..
send me
example :
Let #Pos=instr($Full_Name,'Ramesh',1)

Guest's picture
Re: Instr function in SQR

Can u mail me the sqr related document.
Thanks in advance
Mail id :