Post reply

Discovering field write in lowercase

  • May 5, 2005 at 5:45 am

    #76300

    hello

    I have a database with collation : SQL_latin1_General_CP1_CI_AS

    I need a TSQL command to detect in a text field if i have letters in lower and then return to me this values.

    I don´t know if possible because my collation is "CI"

    ex: 123a456

    Thanks for your help.

    Luis Santos

     

     

     

  • May 5, 2005 at 6:43 am

    #557032

    Well one thing you could do assuming I know what you want to do next is just update the field to upper case :

    Update dbo.YourTable set YourField = UPPER(YourField)

    Or to detect the rows :

    Select * from dbo.SysObjects where name Upper(name) collate SQL_latin1_General_CP1_CS_AS ORDER BY NAME

  • May 5, 2005 at 9:31 am

    #557109

    when in doubt you can always use ascii values....







    **ASCII stupid question, get a stupid ANSI !!!**

  • May 5, 2005 at 9:46 am

    #557121

    Here's a good article on case sensitive comparisons

    http://www.databasejournal.com/features/mssql/article.php/3487696

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply