Case check query

[Thai]

Hello, can someone tell me how make an SQL query to return all records to a recordset where a field's text is all caps?

Thanks,
Thai

[lenin]

Sorry Thai, not sure what you are asking, can you elaborate a bit.

Thanks

Lenin

[Thai]

Oh I just wanted to know how the sql statement that would return all records WHERE field1's text is all caps.

Example:

Record1: Test, test, TEST
Record2: test, test, test

so the sql statement would look at field 3 and only return record1.

But I figured it out :)

Thanks,
Thai