How do I return all of the text to the left of a comma? 2

[Mack2]

Hi everyone,

I need a string manipulation function to return all of the text to the left of a comma. For example..

City, Large: Territory
Suburb, Midsize:

With the two records above, I would like to return "City" for the first record.
For the second record, I only want to return suburb.

Thank you for you help!!!!

 

[RiverGuy]

SELECT LEFT(YourColumnName, CHARINDEX(',', YourColumnName, 1) - 1)

 

[gmmastros]

Better yet....

SELECT LEFT(YourColumnName, CHARINDEX(',', YourColumnName [!]+ ','[/!],  1) - 1)

This protects you in case there is no comma in the data.

Ex:

Declare @Test table(YourColumnName VarChar(100))

Insert into @Test Values('City, Large: Territory')
Insert into @Test Values('Suburb, Midsize:')
Insert into @Test Values('No Comma')

SELECT LEFT(YourColumnName, CHARINDEX(',', YourColumnName + ',',  1) - 1)
From @Test

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Mack2]

Perfect!!!! Thanks!!