Home Forums SQL Server 2005 T-SQL (SS2K5) find whether a upper case letter is there in a given string RE: find whether a upper case letter is there in a given string

  • "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.