CREATE FUNCTION dbo.RemoveSpecialChars1 (@pSomeString VARCHAR(8000))

RETURNS VARCHAR(8000) WITH SCHEMABINDING AS

BEGIN

--===== Delete all special characters except spaces.

WHILE PATINDEX('%[^a-zA-Z0-9 ]%',@pSomeString COLLATE Latin1_General_BIN) > 0

SET @pSomeString...

Only SQL i am struggling with is below now

-------------------------------------------------------------------------------------------------------------------------

string with ONLY special characters (Avoid a-z 0-9 and Double Bytes ,Chinese and Japanese koren russian any other char too)

for that i...

Only SQL i am struggling with is below now

-------------------------------------------------------------------------------------------------------------------------

string with ONLY special characters (Avoid a-z 0-9 and Double Bytes ,Chinese and Japanese koren russian any other char too)

for that i...

Only SQL i am struggling with is below now

-------------------------------------------------------------------------------------------------------------------------

string with ONLY special characters (Avoid a-z 0-9 and Double Bytes ,Chinese and Japanese koren russian any other char too)

for that i...

Only SQL i am struggling with is below now

-------------------------------------------------------------------------------------------------------------------------

string with ONLY special characters (Avoid a-z 0-9 and Double Bytes ,Chinese and Japanese koren russian any other char too)

for that i...

HI

I have solved most of queries below getting idea from sample queries given by "SSC-Dedicated"

thanks a lot

CREATE FUNCTION remove_duplicate_characters (@string varchar(100))

returns varchar(100)

BEGIN

DECLARE @result varchar(100)

set @result=''

select @result=@result+min(substring(@string ,number,1)) from

(...

CREATE FUNCTION remove_duplicate_characters (@string varchar(100))

returns varchar(100)

BEGIN

DECLARE @result varchar(100)

set @result=''

select @result=@result+min(substring(@string ,number,1)) from

(

select number from master..spt_values where type='p' and number between 1 and len(@string ))...

Hi Thanks a lot for helping me , most of the queries helped me, below one is not working for string that starts

with consecutive numbers

-- 3. string that starts...

asdfas