Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

instr like function in SQL

Status
Not open for further replies.
cbochner

cbochner

Programmer
Nov 20, 2006
13
US
Hi,

Is there a way to find a string within a strin in SQL the same way you do it in VB (Instr)?

I'm wracking my brain and can't seem to find anything helpful yet.
 
Sort by date Sort by votes
And what about the Like operator ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
I know Oracle has an INSTR function, but I don't know if it's ANSI standard or not.
 
Upvote 0 Downvote
Nope - just confirmed it is NOT ANSI standard. So I would say LIKE is your best bet.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
204
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
147
harfri
harfri
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
188
JarlH
JarlH
jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
178
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top