SQL: Remove one Character from a string

T00176

SELECT AdviserId, StudentId, DepartmentId FROM dbASADev.dbo.T_Term_Advisor

SELECT SUBSTRING(AdviserId,1,1)+SUBSTRING(AdviserId,3,4) FROM [dbASADev].[dbo].[T_Term_Advisor]

UPDATE [dbASADev].[dbo].[T_Term_Advisor] SET AdviserId=(SUBSTRING(AdviserId,1,1)+SUBSTRING(AdviserId,3,4))

T0176

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s