字段内容里有不可见字符,不是空格,怎么去掉?
select * from col like '%'+char(9)+'%'select * from col like '%'+char(10)+'%'select * from col like '%'+char(13)+'%'chr(9)表示打出一个TAB键的空格！
<html><head><title>VBscript</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body><script language="VBScript" type="text/VBScript">alert "a"&chr(9)&"b"&chr(10)&"c"&chr(9)&chr(10)&"d"</script></body></html>
浙公网安备 33010602011771号