SELECT STRING AFTER A SPECIFIC CHARACTER

Declare @mySQL Varchar(100) 
Set @mySQL = 'Hello-Can anyone help me'
Select Substring(@mySQL, CharIndex('-', @mySQL) + 1, LEN(@mySQL))
Select LEFT(Substring(@mySQL, CharIndex('-', @mySQL) + 1, LEN(@mySQL)),1)

Reff: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/e49f5d34-023c-4bb2-8825-04411029ee92
Advertisements
By simplemsexchange Posted in SQL 2008

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s