CODEWITHSUNDEEP
sqlsql-server
Sachin
Sachin

Reputation: 1

How to remove blank spaces from a string in SQL Server 2008?

I Have strings suppose '1234 567890' and 'SQL Server', now i want to remove blank spaces from the strings .Anybody got any idea how to do it. Thanks in advance.

Upvotes: 0

Views: 120

Answers (1)

A_Sk
A_Sk

Reputation: 4630

select Replace('1234 567890',' ','')

REPLACE (string_expression,string_pattern,string_replacement)

Upvotes: 2

Related Questions