"from a given field in a table i want to retrieve only those rows doesnt contain any upper case letter in any position."
Why not just do something simple like:
select * from myTable
where myField = lower(myField)
That would return the rows that do not have any uppercase letters in the field in question.