Using WildCard Character
-
Hi, In my application i have a search criteria field in which one document name field is there. I have a document in my database with name $#%#$. Now, I want to search for document by entering only %. How i do that? I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document. Thanks, Umesh Tayade
-
Hi, In my application i have a search criteria field in which one document name field is there. I have a document in my database with name $#%#$. Now, I want to search for document by entering only %. How i do that? I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document. Thanks, Umesh Tayade
I can see you use the LIKE in your query. If you only enter % you do get all. If you enter #%# I guess your result will be better. (BTW I have never seen a filename with a % in it, maybe de-abstract you question)
In Word you can only store 2 bytes. That is why I use Writer.
-
Hi, In my application i have a search criteria field in which one document name field is there. I have a document in my database with name $#%#$. Now, I want to search for document by entering only %. How i do that? I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document. Thanks, Umesh Tayade
-
Hi, In my application i have a search criteria field in which one document name field is there. I have a document in my database with name $#%#$. Now, I want to search for document by entering only %. How i do that? I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document. Thanks, Umesh Tayade
You can use either SELECT columns FROM table WHERE column LIKE '%[%]%' -- or SELECT columns FROM table WHERE column LIKE '%\%%' ESCAPE '\'