DataType

Yes, CAST is ANSI standard, while CONVERT is MS-specific. MS recommends to use CAST whenever possible. So you'll find the only use of CONVERT when using some style parameter when moving from DATETIME to some specific date format.

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

BOL is the commonly used abbreviation for the SQL Server online manual Books Online.

just call me Frank...

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Ok Kalis [}<img src='/community/emoticons/emotion-1.gif' alt='' />][<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br /> <br /><br />just call me Frank...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

I don't know how this is handled in other societies exactly, but here it is regarded impolite and dismissive to call someone by just his last name. Either someone's first name or by adding Mr. or Mrs. I am aware that this differs from how other folks handle this and I don't feel offended by this, but it always looks strange to me.

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

As I said, I am aware, that other cultures handle this different and most folks make the mistake not to talk about such things and learn from each other. <br /><br />Not need to apologise! [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />But while we're at it. What is the difference when I call you "Rajesh" instead of "Kolli"?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>

Yes, but when I call you Rajesh instead of Kolli, what is more polite or appropriate?

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by rajkolli_2000</i><br /><br />Ok Frank.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />It is better to call the member by the user name of the Forum [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />Dont cut anything<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

I believe the topic is discussed and I;m sure Rajesh is happy with the content, rest of it is just a wayup from the discussions.<br /><br />(I'm sure Frank will be waiting to wind me up [<img src='/community/emoticons/emotion-1.gif' alt='' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided �AS IS� with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Nope. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />Though I don't have an answer to my question...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>