05 June, 2011

Case sensitive filtering in SQL server

For case sensitive:
put COLLATE SQL_Latin1_General_CP1_CS_AS after filer........
For Case incensitive:
put COLLATE SQL_Latin1_General_CP1_CI_AS after filer........


Example: select * from tablename where upper(columnNmae1)!=columnNmae1 COLLATE SQL_Latin1_General_CP1_CS_AS

16 May, 2011

Alert box with line breaks

function disp_alert()
{
alert("Hello again! This is how we" + '\n' + "add line breaks to an alert box!");
}