弱智问题

[xq02]

一个sql语句
select * from table where aa like '+QuotedStr(Edit1.Text)+'
问题是想在Edit1.Text上加%通配符,怎么做?
谢谢!

[xwdxwd]

select * from table where aa like '+QuotedStr(Edit1.Text)+'%''

[xwdxwd]

select * from table where aa like ''+QuotedStr(Edit1.Text)+'+'%''

[xq02]

楼上,不行啊

[kkgogo]

select * from table where aa like '+quotedstr(edit1.Text)+'%''

[lijinghe1]

'select * from table where aa like '+QuotedStr(Edit1.Text+'%')

[colorbird]

select * from table where aa like '+QuotedStr(Edit1.Text)+'%''