freeadulru
New Member
I don't understand what what the purpose of using "^" in the second code?
Another problem is that I don't retrieve right information in second code compare to the first code. Why? \[code\]-- First code, use adventurework DW 2008select FirstName, LastName from DimCustomerwhere LastName like '[j-N]%'order by LastName-- Second code, use adventurework DW 2008select FirstName, LastName from DimCustomerwhere LastName like '[^L-N]%'order by LastName\[/code\]
Another problem is that I don't retrieve right information in second code compare to the first code. Why? \[code\]-- First code, use adventurework DW 2008select FirstName, LastName from DimCustomerwhere LastName like '[j-N]%'order by LastName-- Second code, use adventurework DW 2008select FirstName, LastName from DimCustomerwhere LastName like '[^L-N]%'order by LastName\[/code\]