db question

Oracle db

I want to check if the first character of the field, 'Name' is "L". I got problem with 'Like'. Besides 'Like', is there anything else I can use for this purpose?

***********
cnn1.Open "Driver={Microsoft ODBC Driver For Oracle};UID=PO8;PWD=PO8;"

rs.Open "select Name from test WHERE name Like 'L*'", cnn1

**************

Something wrong with the 'Like' operator. it returns 'eof' when the field, Name has the value of 'Linda'.

Something wrong with my syntax?

Thanks

Hai,

The wild card charactor supported by oracle is '%'. So your second line should be

rs.Open "select Name from test WHERE name Like 'L%'", cnn1




All the best and regards

Kishore