var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: strip text from a string
I'm trying to find a way to strip text from a string. In the past (pre SQL Server) I would've used
To strip the last name from a string like
Apparently InStr is not a recognized function in SQL Server 2000. Or is it available but not in a view?
Any thoughts would be greatly appreciated.
Re: strip text from a string
declare @name varchar(30)
select @name = 'Franks,George J'
select left(@name, (charindex(',', @name) - 1))