db question

[lindawqu]

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

[Kishore A R]

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