Howdy!

Is it possible to put RIGHT$ Functions inside Select statements. If so, how?

I tried this and received no errors, but I also received no records.

Set adoSearchRS = New Recordset

strClass = "00"
SQL = "Select Distinct ClassNum from Table1 where
right(ClassNum = '" & strClass & "'" & ",2)"

adoSearchRS.Open SQL, db, adOpenStatic, adLockOptimistic

I want to pull all fields that end in 00


Thanx