Wednesday, May 13, 2009

Removing spaces between words in sql

Removing spaces between words in sql: "Use the replace function.
replace( @Data, ' ', '' )
For example,
DECLARE @Data varchar(1000)
SET @Data = 'I ran very fast'
SELECT replace( @Data, ' ', '' )
---------------------------------
Iranveryfast"

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

More Important Links

Followers