I get an error from a datatable select statement which contains a LIKE clause reading "... LIKE 'AC* %' ..."
The error reads "the string pattern AC* % is invalid".
Why ? * is not a wild card, so where is the problem ?
My application is written in VB.Net (VS 2013), it runs on Windows Server 2008 R2.
The same statement has worked on about another 400 selects with other data, where the part before the space did not have a * at the end.
Thanks for help