Hello,
i'm trying to do a LIKE filter to a numeric column.
the idea is that i could make a LIKE filter just as i would on a varchar column.

any ideas?

Did you try using % as part of your LIKE filter?  For example, if you wanted all numbers that begin with a 12 then you would enter something like the following:

SELECT ....... FROM .........WHERE ...... LIKE '12%'



If that doesnt answer your question then please explain in more detail...

I'll explain in details.

i want to use ADO Recordset's Filter property to remove unwanted rows from the recordset.

I want to do it in the recordset (in RAM) and not to re-query the SQL server.

The Recordset object has a property called "Filter" which gives a quick way to filter the rows.

but this property is not 100% SQL. therefore, it does not support LIKE statement for numeric columns.

i'm looking for a way to do it anyway (maybe some mathematical way....)

btw, the simple LIKE statement with % or * does not work.

thanks.

Try this

rs.filter = "fieldname like 'SW%'"

It worked on my pc


Steve  

Hi.
your code did not work for me.

does your "fieldname" column is a numeric column?

in my table, the column is a "int" type.
therefore, "LIKE" is not posible on it.

i'm looking for a trick or something that will allow me to do it or simulate it.

thanks

Some tries I'd do:

rs.filter = "fieldname LIKE " & CStr(12) rs.filter = "fieldname LIKE " & Chr(34) & CStr(12) & Chr(34) rs.filter = "fieldname LIKE " & Chr(Asc("1")) & Chr(Asc("2")) rs.filter = "fieldname LIKE " & Chr(34) & Chr(Asc("1")) & Chr(Asc("2")) & Chr(34)

Hope one could match.


____________________________
Real Programmer can count up to 1024 on his fingers

Hi yronium,
What version of VB have you tried it on?
i'm using VB6 SP5.
Does the column "fieldname" (in your tests) is a numeric column (int,lomg, etc) ?

I didn't try it, "I'd do" was meaning "I would do".
I use VB6 SP5 too, for what it matters.

I would do these attempt in order to retrieve the string value even from a stored number. I don't have a column named "fieldname": I just reported the name of the previous post. But I would try to convert the numeric value in my field into a string. So try it: if it works (I hope at least one does), it does even on numeric columns.

Let us know.

____________________________
Real Programmer can count up to 1024 on his fingers

Hi.
i've tried the code you suggested.
all four does not work.
the ones without the ' char does not  cause error, but also does not filter.

any other ideas? i'll gladly try more

thanks

Hi

What version of ado are you using, and can you please post your code here?

Steve  

hi try this it may help
its for vb6

retrieve the data and convert it to string
then use the like "%" statement


dim phone as string
phone=text1.text
'whether the data in text1 is numeric or char
'all is handled as string
datacontrol.comandtype=adcmdtext
dtacontrol.recordsource="select_from _ where _ like'"+phone+"%'"
datacontrol.refresh

ben


____________________________
Its all possible