# mark in searching

[wojtasik6]

Hi there,
I've got a bit of a problem with # mark when I want to search a number containing "#". The number is as follows: 33.#5hy4-1234
When I insert a part of this number to a textbox eg. #5hy to search records containg it, it gives me no results (despite there are such in a database) I know that it is to do with this # mark.
I have an sql query: (...) where sachnummer like '*" & variable & "*'

So is there any way to get round this problem? To find records containing that special mark?

 

[namliam]

use square brackets:
like "*[#]*"

 

[wojtasik6]

Thank you. It works when I put this number into textbox.
But can I somehow do it in the code with variable (value from textbox) so that in textbox I type # without square brackets?

 

[namliam]

you can try to use the replace function