Usage of mssql replace

Use the stuff function.

stuff ( character_expression , start , length ,character_expression )

parameter character expression

A character data expression. A character expression can be a constant, a variable, or a column of characters or binary data.

start is an integer value that specifies where deletion and insertion begin. If start or length is negative, an empty string is returned. If start is longer than the first character expression, an empty string is returned.

Start can be of type bigint.

length

An integer that specifies the number of characters to remove. If the length is longer than the first character expression, up to the last character in the last character expression is removed. Length can be of type bigint.

Return Type Returns character data if character expression is a supported character data type. If character expression is a supported binary data type, binary data is returned.

Note If the start position or length value is negative, or if the start position is greater than the length of the first string, an empty string is returned. If the length to be removed is greater than the length of the first string, the first character in the first string will be removed.

If the result value is greater than the maximum value supported by the return type, an error is generated.

Example The following example creates and returns a string by removing the three characters starting at the 2nd position (character b) in the first string abcdef, and then inserting the second string at the beginning of the deletion.

select stuff('abcdef', 2, 3, 'ijklmn');

Here's the result set:

aijklmnef

1 row(s) affected)

update ceshi set nr=replace(itemname,'x','klj') where itemname like '%x%'

It's definitely okay to write like this, I've tested this, you can try it.

I don't know how many of those symbols you're going to remove, but if you could list them all, there's a dumber way to do it.

Nesting uses replace

select replace(replace(column name,'ɦ'，‘’621’,'')

How to use replace:

replace ( ''string_replace1'' , ''string_replace2'' , ''string_replace3'' )

parameters''string_replace1''

string_replace2''

The string expression to be found. string replace2 can be either character data or binary data.

string_replace3''

Substitution of string expressions. String replace3 can be either character data or binary data.

The return type is a string.

I haven't used this function, but based on subjective feelings, it seems that the substitution function with other languages should be a truth.

So, write it like this in the following way, and it should work!

Yes or no, you can give it a try.

replace(replace(,'e','Investigation'),'g','business')

You can write this in two parts, you can update it directly without replacement.

select case when trip_type = 'g'then 'business'

when trip_type = 'e'Then 'investigate'

endfrom table;

There is also a replace that can also be used in select.

e.g. sql> select * from dual a ; dummy

x sql> select replace (dummy , 'x' , 'Zhang San') from dual a ;

replace(dummy,'x','Zhang San')

Zhang San: If you want to replace more than one, you can also do it.

select replace (dummy , 'x' , 'Zhang San') from dual a where dummy ='x'

union all

select replace (dummy , 'g' , 'Zhang 1') from dual a where dummy ='g'

union all

select replace (dummy , 'e' , 'Zhang 2') from dual a where dummy ='e';

select case when g then'business' when e then 'Examination' end

from [table name].

Regularization is a general-purpose technique that does not distinguish between languages.

Like g, there are only 3 blocks.

They are g, i, and m

g indicates the full-text search of the reed chain.

i indicates that case is ignored.

m indicates a multi-line query.

Generally, only the first two are used, and the third is rarely used. I didn't have to accompany my grandson either.

Replace is not wrong, it's your way of thinking.

Replace can only return 1 value at best, and all you pass is a string, which is a value.

It's not very easy to split it into multiple values.

In this case, it is usually as concatenating SQL, exec to execute the statement, or using the charindex function to spell up the characters.