By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

how INDEX works in Ms Access

P: n/a
HI Experts
am trying to split "Srinath Reddy Kanuganti:Kanuganti GCI" in to two
parts
Srinath Reddy Kanuganti and Kanuganti GCI
which is seperated by (:)
i tried with Select
mid$ (tpcname,1,PATINDEX('% %',tpcname))
from tab;
and used INDEX insted of PATINDEX ...
sitll no luck with LEFT insted of MID

my requirement is to get the first part of the name from the column

pl help me

Thanks in advance
Mar 7 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, 7 Mar 2008 04:22:51 -0800 (PST), Testingg
<sa**********@gmail.comwrote:

patindex is a T-SQL function, and not available in Access.
You can use the InStr function instead.
In some cases (but not in a query) the Split function can be used.

-Tom.

>HI Experts
am trying to split "Srinath Reddy Kanuganti:Kanuganti GCI" in to two
parts
Srinath Reddy Kanuganti and Kanuganti GCI
which is seperated by (:)
i tried with Select
mid$ (tpcname,1,PATINDEX('% %',tpcname))
from tab;
and used INDEX insted of PATINDEX ...
sitll no luck with LEFT insted of MID

my requirement is to get the first part of the name from the column

pl help me

Thanks in advance
Mar 7 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.