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

On Fri, 7 Mar 2008 04:22:51 -0800 (PST), Testingg
<sanathsharma (AT) gmail (DOT) com> wrote:

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.