M
mosscliffe
I have been messing with the above all afternoon.
I must just be thick
I am using an AccessDataSource
I have tried modifying the select but I can not find the right syntax
to concatenate the LIKE part of the test by surrounding my textbox
field value with a leading and closing %.
I have tried the filter property but that is a bit of a mystery, I
can't work out how to create Filter Expression.
What is the quickest and best method. People must do this hundreds of
times a day.
DataSource SELECT Select * from glossary where name like '%' +
'@PARAM' + '%' >>>FAILS (SQL ERROR)
DataSource SELECT Select * from glossary where name like '%' + 'word'
+ '%' >>>>WORKS
Please help and thanks in advance.
Tim
I must just be thick
I am using an AccessDataSource
I have tried modifying the select but I can not find the right syntax
to concatenate the LIKE part of the test by surrounding my textbox
field value with a leading and closing %.
I have tried the filter property but that is a bit of a mystery, I
can't work out how to create Filter Expression.
What is the quickest and best method. People must do this hundreds of
times a day.
DataSource SELECT Select * from glossary where name like '%' +
'@PARAM' + '%' >>>FAILS (SQL ERROR)
DataSource SELECT Select * from glossary where name like '%' + 'word'
+ '%' >>>>WORKS
Please help and thanks in advance.
Tim