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.
| Author |
Topic |
|
nuruddean
Starting Member
11 Posts |
 Posted - 2010-08-04 : 01:04:09
|
| how i want to do substr this : Head.165-Matriculation Centrei just want to get 'Head' or any word before the first "."My Name is Nuruddin |
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-04 : 01:43:20
|
| give clarity to your needWith RegardsKashyap M |
 |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-08-04 : 01:45:45
|
| declare @s varchar(255)set @s = 'Head.165-Matriculation Centre'Select case when charindex('.',@S) > 0 then left(@s, charindex('.',@S) -1 ) else @s endI am here to learn from Masters and help new bees in learning. |
|
|
|
|
|
|
Substr Lesson