这条语句怎么写(50)

J

jiangxidna

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #1

我想实现：select * from table where fieldname like 'field%'我用delphi编程，用的是sql server数据,设置了变量：temp语句实现： select * from table where fieldname like '''+temp+''''+'%但是不正确，通过数据库工具发现确实不正确，不知道哪位兄弟知道怎么弄

 

Z

zhengrong117

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #2

select * from table where fieldname like '''+temp+'%'''+'44这样呢？

 

O

ouyangzhifei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #3

var temp,str:String;........ str:= temp +'%'; select * from table where fieldname like '''+str+'''

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #4

insert('%',temp,n);//n为temp的长度+1select * from table where fieldname like '''+temp+''''

 

Z

zaorv

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #5

temp:='field%'cslq:='select * from table where fieldName like ' +quotedStr(temp);

 

W

wllxf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #6

var temp:String;SQL语句为：'select * from table where fieldname like ' + QuotedStr(temp + '%')'

 

J

jiangxidna

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-07-03

• #7

谢谢诸位大哥！小弟分少了，就这样将就吧！！呵呵