How to change datatype using replace function in SQL Server

Question

select
    replace(Street, char(10), '')
from streettable

Have explored the syntax of replace function ...but how does this piece of code work?

What exactly are you trying to do? REPLACE is usually used to change the content of a value rather than its type. — Hysteria86
– Hysteria86, Commented Jun 15, 2015 at 12:04
This is not changing the type, in this case CHAR(10) is not defining a type of CHAR with a length of 10, is it the scalar function CHAR() returning the ASCII character 10 (line feed). — GarethD
– GarethD, Commented Jun 15, 2015 at 12:11

Giorgi Nakeuri · Accepted Answer · 2015-06-15 12:15:55Z

3

The sample code doesn't change datatype. char(10) is line feed and the code just replaces line feeds with empty symbol in street column(not in table, but on the fly to present. Data in table stays untouched).

If you want to change datatype then you should alter the column. Something like:

alter table streettable alter column Street varchar(777) null

edited Jun 15, 2015 at 12:15

answered Jun 15, 2015 at 12:08

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to change datatype using replace function in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related