Replace 1st char in a string if not null

Question

Replace 1st char in a string if not null

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99143 More actions · Answer 1

STUFF is really handy for things like this:

STUFF(Mobile,1,1,'')

That will remove the first character of the from the column Mobile. The function is very commonly used when creating delimited list in SQL Server, as removing the first character from a string is far easier than removing the last.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Jay@Work SSCrazy Points: 2633 More actions · Answer 2

Works perfectly, thanks! Also doesn't complain when it is passed NULL which is a bonus