查询空字段_sql 如何查询 空值的字段？

展开全部

sql查询空值的字段写法：SELECT A.字段 FROM student  A WHERE A.字段 LIKE'% %' (student为表名32313133353236313431303231363533e78988e69d8331333431366430)

查询类似空值的写法:

1、查询名称有退格键：select * from t_bd_item_info  where charindex(char(8),item_name) > 0 go

2、查询名称有制表符tab：select * from t_bd_item_info  where charindex(char(9),item_name) > 0 go

3、查询名称有换行：select * from t_bd_item_info where charindex(char(10),item_name) > 0 go

4、查询名称有回车：select * from t_bd_item_info where charindex(char(13),item_name) > 0 go

5、查询名称的空格(前空格、后空格、所有空格)：select * from t_bd_item_info where isnull(charindex(' ',item_name),0) > 0 go

6、查询名称的单引号：select * from t_bd_item_info where charindex(char(39),item_name) > 0 go

7、查询名称的双单引号：select * from t_bd_item_info where charindex(char(34),item_name) > 0 go

扩展资料

1、处理名称有退格键

update t_bd_item_info set item_name = replace(item_name,char(8),'')

where charindex(char(9),item_name) > 0 go

2、处理名称有制表符tab

update t_bd_item_info set item_name = replace(item_name,char(9),'')

where charindex(char(9),item_name) > 0 go

3、处理名称有换行

update t_bd_item_info set item_name = replace(item_name,char(10),'')

where charindex(char(10),item_name) > 0 go

4、处理名称有回车

update t_bd_item_info set item_name = replace(item_name,char(13),'')

where charindex(char(13),item_name) > 0 go

5、处理名称的空格(前空格、后空格、所有空格)

update t_bd_item_info set item_name = replace(rtrim(ltrim(item_name)),' ','')

where isnull(charindex(' ',item_name),0) > 0  go

6、处理名称的单引号

update t_bd_item_info set item_name = replace(item_name,char(39),'')

where charindex(char(39),item_name) > 0 go

7、处理名称的双单引号

update t_bd_item_info set item_name = replace(item_name,char(34),'')

where charindex(char(34),item_name) > 0 go