Does some one know, how to use wildcards with ado.net parameter in sybase sql anywhere?
For example i want to search for all names, starting with Se
. In a normal query i would use select * from names where name like 'Se%'
. But in ADO.Net my query looks like SELECT * from names where name like ?
and the question mark will be set over SAParameter
.
SACommand command = new SACommand(SqlStatement, cConnection);
command.Parameters.Add(new SAParameter() { Value = "Se%" });
The problem is, Value
could not contains any wildcards.
Thank you very much!
here's my solution example