Split 1 column value into two columns using delimiter as HyphenHi friends,
I need to split a single column value into 2 columns.
declare @cUser varchar(255)
set @cUser='John williams - Mercury Production'
I want to split the name and company name into 2 different columns against the delimiter Hyphen..
I tried a solution, it gives out the result in single column multiple rows....
Can anybody help me out to perform the above task?
Thanks in Advance