When exporting some data from MS SQL Server using Python, I found out that some of my data looked like <code>computer \xa0systems</code> which is causing encoding errors. Using SQL Management Studio the row simply appears to be double spaced: <code>computer systems</code>. It seems that this is the code for <code>&nbsp;</code>: how can I query MS SQL Server within management studio to find all instances of this? things like <code>WHERE ColumnName LIKE % %</code> are not working, nor are querying on <code>nbsp;</code> or <code>\\xa0</code>

I used <code>WHERE ColumnName LIKE '%' + CHAR(160) + '%'</code> 160 is the ascii for "non breaking space".. which is 0xA0 in hex as per your \xao

Query MS SQL for empty spaces(  or \xa0)

When exporting some data from MS SQL Server using Python, I found out that some of my data looked like computer \xa0systems which is causing encoding errors. Using SQL Management Studio the row simply appears to be double spaced: computer systems. It seems that this is the code for  : how can I query MS SQL Server within management studio to find all instances of this? things like WHERE ColumnName LIKE % % are not working, nor are querying on nbsp; or \\xa0

How do I select a space in SQL?

To select a column name with spaces, use the back tick symbol with column name. The symbol is ( ` `). Back tick is displayed in the keyboard below the tilde operator ( ~).

I used WHERE ColumnName LIKE '%' + CHAR(160) + '%'

160 is the ascii for "non breaking space".. which is 0xA0 in hex as per your \xao

Query MS SQL for empty spaces(  or \xa0)

Tags:

sql

unicode

ascii

iboeno

People also ask

1 Answers

gbn

Recent Activity

Donate For Us

Query MS SQL for empty spaces(&nbsp; or \xa0)