[ spartanac86 @ 11.09.2008. 13:16 ] @
SELECT UserId
FROM aspnet_membership
WHERE email = '[email protected]' COLLATE SQL_Latin1_General_CP1_CI_AS

sa sajta : http://aspadvice.com/blogs/ssm...-or-Insensitive-SQL-Query.aspx


Error ora 00-933:
SQL command not properly ended!!


Kako da nateram ovakve upite da rade u Oracle?? hitno mi treba case insensitive upit!!
[ djoka_l @ 11.09.2008. 15:29 ] @
Code:
SELECT UserId
FROM aspnet_membership
WHERE upper(email) = upper('[email protected]')
[ spartanac86 @ 11.09.2008. 22:19 ] @
e bas sam se setio toga i to sat vremena pre nego sto si odgovorio a celo jutro razmisljam. samo sto sam ja stavio lowercase, ali to je to :)
zasto bi bilo prosto kad moze komplikovano, ne znam zasto svi na netu rade preko ovog collate...

u svakom slucaju hvala