I am using OLEDB with VB.NET and I'm trying to make a like statement that will pull all records from an Access database that does not start with a letter. This works in Access: LIKE '#*'
I know the wildcards are different for ADO so I have tried these:
LIKE '#%' <-- Gives no error but no resultes eather. There are no records that start with the # symbol.
I even tried these and they errored
Are brackes not supported or am I just missing the obvious?
One of my resources: http://office.microsoft.com/en-us/assistance/HP051881851033.aspx