query to retrieve lower case

[shaan1980]

how would I be able to query a table to retrieve all strings that contain a lower case character

eq Table A contains Atrribute B and B has values t,T,y,Y

my query should return t,y

[eelixduppy]

I think you can use MySQL's regex [dev.mysql.com] to achieve this. I don't have much experience with this though.

[coopster]

Regular expression matching is one thing, returning the values in the matched pattern is another. Different databases will offer different variations, but to the best of my knowledge MySQL does not currently return matched patterns, this is often done by using server-side scripting languages. The entire field value is returned and you then run the value through a regular expression to retrieve subpatterns.

[shaan1980]

I'm using Sybase .

[syber]

SELECT columnB
FROM tableA
WHERE ASCII(columnB) > 96

[shaan1980]

Thanks .