try this code...

suppose you have the table 'tblNames' with a column 'name'

select left(name,charindex('-', name)-1)

from tblNames union all

select left(name,charindex('/', name)-1)

from tblNames

havent tried it... i'll try this code at home...

but...

put more detail on your question so as that somebody can help you about your problem...

try visiting this link --- http://www.sqlservercentral.com/articles/Best+Practices/61537/

that was confusing!

like a lady who changes her mind very every now and then.. 😀

but anyway, i think they should give the points on this one...