• Dineshbabu (1/7/2013)


    simply I selected one to see the explaination and understand the qstn. Really i didn't understand what the qstn is delaing abt...

    Can anyone xplain in detail. If already xplained pls provide me the refernce..

    Thanks

    Did you read all the posts so far in this topic?

    The short story - in some languages, Æ and æ are official letters. They can also be written as AE and ae. Because of that, 'Æ' LIKE '[AEIOU]' will return true - because the first two letters in the LIKE string (A and E) are considered to represent the Æ character.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/