Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 search a character in field

Author  Topic 

pkuchaliya
Starting Member

49 Posts

Posted - 2008-08-08 : 03:53:00
Hi ,

any body can tell how i can search the character in a string like

create table employ (name_emp varchar(50))

insert into employ('Pankaj kuchaliya')
i want to search the space position in the name_emp field

pankaj

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-08 : 03:54:26
look at CHARINDEX in Books Online

Em
Go to Top of Page
   

- Advertisement -