@Bandi
User(s) may be beginners. So, How do they know that "What you were thinking?". (IF/IF NOT kind of thing)
So, If you want to say something more. You have to sepcify that too!
Do you think, You can store the result of the following into another Table with CASE SENSITIVE???
-- retruns 1 record
SELECT LAST_NAME COLLATE SQL_Latin1_General_CP1_CS_AS FROM EMPLOYEES
WHERE LAST_NAME COLLATE SQL_Latin1_General_CP1_CS_AS = 'Abel'
-- retruns Zero record. Because it searches for case sensitive data
SELECT LAST_NAME COLLATE SQL_Latin1_General_CP1_CS_AS FROM EMPLOYEES
WHERE LAST_NAME COLLATE SQL_Latin1_General_CP1_CS_AS = 'abel'
1. If you want to use "SELECT...INTO" it won't work!!!
2. If you want to use "INSERT TableName SELECT..." That table should be created earlier before using it!!!
If one of the user want to store into an another NEW table. Can they use above query ?? Will it work ?
Do you aggree ?
Hanishani, if this helps please login to Mark As Answer. | Alert Moderator