求一sql语句

[一路奔跑1314]

有一变量strname=session("xm")
有一表为tabA,其中一字段为lct
求tabA中字段lct包含strname的记录
strsql="?"
请问？号处该如何写

[lin11211408]

select lct from tabA where lct like '%strname%'

[Change_L]

string.Format("select * from tabA where lct='{0}',strname);

[md5e]

sql="Select * From tabA Where lct='"+ strname +"'"

[yhj464079080]

string strsql= string.format(" select * from tabA where lct like '%{0}%'",strname);

[白云任去留]

string strsql = "Select * From tabA Where CHARINDEX('"+ strname +"',lct)>0";

[一路奔跑1314]

引用 1 楼 lin11211408 的回复:

select lct from tabA where lct like '%strname%'

不对，直接把strname当字符串了

[天下如山]

string.format(" select * from tabA where CHARINDEX('{0}',lct)>0",strname);
string.format(" select * from tabA where lct like '%{0}%'",strname);

[yhj464079080]

string strname=session("xm").toString(); string strsql= string.format(" select * from tabA where lct like '%{0}%'",strname);

[LemonSmile_]

string.format("select * from tabA where ict like '%{0}%'",strname);

[yinshizi]

引用 4 楼 yhj464079080 的回复:

SQL code?1string strsql= string.format(" select * from tabA where lct like '%{0}%'",strname);

+1

[EnForGrass]

string sql=" select * from tabA where CHARINDEX('"+strname+"',lct)>0"; charindex的用法请参考http://www.cnblogs.com/lkvm114/archive/2011/03/06/1972261.html

[Dotar]

如上 回帖

[梅梅2012]

引用 8 楼 yhj464079080 的回复:

string strname=session("xm").toString(); string strsql= string.format(" select * from tabA where lct like '%{0}%'",strname);

+1