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.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.