MS SQL Anomalies 3

..contributing to IT in London since 2002..

MS SQL Anomalies 3

For those who are still using ancient data types such as CHAR be carefull if you are also using REPLACE function in MS SQL servers:

Let’s test VARCHAR and CHAR fields on a simple table like the following:

The output is:

Replace function on char field

(version MS SQL Server 2000)

As usual, Microsoft developers are full of surprises!

 

No Comments

Add your comment