Search substring - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Search substring

Author

Topic

kwikwisi
Constraint Violating Yak Guru

283 Posts

Posted - 2011-11-23 : 22:52:02

hi,

How to get substring from a string before first space ?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-11-24 : 00:52:16

select left(col,charinex(' ',col)-1) from table

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources