在2000中从SQL查询中获取带引号的数据 [英] To get the data with quotation mark from sql query in 2000

问题描述

假设我的数据值存储在table1中
数据类型为varchar数据类型为``D0001''

如何通过带引号的查询来查询该类型的数据值(即``D0001'')????
请帮助我.....

Suppose my data value is store in table1
The data value is ''D0001'' in varchar data type

How can i pick up by query of that type of data value(i.e. ''D0001'') with quotation mark????
Please help me.....

推荐答案

赞一下:

Like this:

SELECT * FROM MyTable WHERE MyColumn = '''D0001'''

想法是使用双引号.

The idea is to use double quotes.

SELECT * FROM MyTable WHERE MyColumn如''％D0001％''


当使用以varchar作为数据类型的字段时.

最好与like语句一起使用.

SELECT * FROM MyTable WHERE MyColumn like ''%D0001%''


when using the field with varchar as an datatype.

u better use with like statement.

这篇关于在2000中从SQL查询中获取带引号的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！