SQL Query Help

How do I create a query that only returns distinct values from a field called tireType with values such as:

Truck / SUV - SKU=BF026614
Truck / SUV - SKU=BF5555
Hi-Performance A/S - SKU=BF027209
Ultra High Performance - SKU=BF037036

I would like the query to only this:

Truck / SUV
Hi-Performance A/S
Ultra High Performance

TIA,

Terry
LVL 1
splendorxAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Hello splendorx,

SELECT LEFT (urColumn , PATINDEX('%- SKU%',urColumn)-1  )
from urTable

Regards,

Aneesh
0
 
MNelson831Commented:
Select distinct tireType from MyTableName
0
 
splendorxAuthor Commented:
Thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.