Hi,

SELECT * FROM history WHERE type IN ('L')

seems to ignore case, because I'm getting all
records with both upper and lower case L's.

Is there anyway to trap out the lower case L's?

Thanks,

Tom

PS I tried to search for 'IN keyword', but the search
function says I have to have three characters minimum.