0
I am trying to run the following Query:
select codigo from cliente where codigo ilike '%99.999.999%';
I thought by putting the ilike
, he would ignore everything, points and accents but I was wrong.
In my system, I have a query screen where I prefer that the user does not need to type points... When he searches a CPF for example
Detail: I use this query in a Textchanged of a Textbox
How could I do this query to ignore the dots?
mount the query without the dots..
– Daniel Omine
On my system, I have a query screen where I prefer that the user does not need to type points... When he searches a CPF for example
– Emerson
Remove the dot when passing text from the screen to the query?
– Omni
I’m doing this query in a field in the event Textchanged. At the time he type, already go making the query
– Emerson
if this value is a user input, just remove the points before playing it in the query. You can do this in C# itself or SQL.. The fact that the data comes from a "Textchanged" event makes no difference..
– Daniel Omine