Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Anybody knows InStr() function which is working in Ms Access, but not

0 views
Skip to first unread message

itsts

unread,
Jan 31, 2001, 11:45:23 PM1/31/01
to
Anybody knows InStr() function which is working in Ms Access, but not
functioning in SQL query

thanks in advance

you can email to it...@post1.com

Dan Guzman

unread,
Jan 31, 2001, 11:53:49 PM1/31/01
to
For MSSQL Server, check out the CHARINDEX and PATINDEX functions in the
Books Online.


Hope this helps.

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
-----------------------


"itsts" <it...@post1.com> wrote in message
news:3a78e9dc$1...@news.starhub.net.sg...

0 new messages