Select Statements

[hyme]

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

[paulw]

You can use Right$ but if you just want ending in '00', you would use "SELECT ... WHERE Classnum LIKE '*00';"

I suggest you look at your SQL variable in a MsgBox - you seem to have mangled it somewhat.

Cheers,

Paul.