Remove parts of a varchar field 1

[akalinowski]

I have a table where styles are setup as a number dash size dash color as a single column
i need to get the style out but its not a constant length
is there a way i can cut all data after teh 1st dash
example of the data is

ST123-S-BK
SD23-M-BL
23RDSDFD-M-RD

thanks!

akalinowski

http://www.olivelabs.com

 

[gmmastros]

You can use the CharIndex function to locate the dash and then use that in the LEFT function to get the data to the left of the first dash. Like this:

Select Left(YourColumnNameHere, CharIndex('-', YourColumnNameHere+ '-') -1)

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[akalinowski]

worked like a champ!
thanks gmmastros

akalinowski

http://www.olivelabs.com