Wednesday, 6 November 2013

Remove non numeric character from " String " in SQL

Todays , I bundled with some question . Among them I like to share one solution with you all. Its not too complex , but quite good.

Here some new keywords found
Patindex and stuff

Patindex as we know to returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.

Stuff :
The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.
More info..

Solution to .. :