You can use either CAST or CONVERT. Because CAST and CONVERT provide similar functionality.
The difference is CASE is more ANSI standard and use this only if you are writing a program which you will need to use in many database platforms. Where CONVERT is Microsoft specific and more powerful.
Links:http://msdn2.microsoft.com/en-us/library/ms187928.aspxhttp://searchwinit.techtarget.com/tip/0,289483,sid1_gci1014050,00.html
VN:F [1.1.6_502]Rating: 4.0/5 (1 vote cast)

Govt. of Kerala took a very bad decision to take off Microsoft products from Schools. As far as I know more than 70% of the machines in Kerala (also the whole India) is running on Microsoft Windows. And 25% of the machines use Linux and that too for Server purpose only. Microsoft’s products are giving [...]

This script will let the text scroll contineously. This means, the second round scroll will start just after first round. This will overcome the in-between delay of HTML MARQUEE tag. However, this script is not free from limitations. But works on both IE & Firefox.

var text = “There is a long sentence With some more [...]

This is a quick script from my hands which logs the date and time of windows ‘loging’ and ‘logoff’.

dim objfso, objtextfile
set objfso = CreateObject(”Scripting.FileSystemObject”)
set objtextfile = objfso.OpenTextFile(”f:logsystem.txt”,8,True)
if WScript.Arguments(0) = “LOGIN” then
objtextfile.Write(vbCrLf & Date & ” ” & Time)
else
objtextfile.Write(” - ” & Time)
end if
objTextFile.Close
Wscript.Quit
The output will be like:
11/7/2006 4:15:25 PM - 4:15:27 PM
11/7/2006 4:15:31 PM - [...]