Could someone explain the following sql-statement for me ?? This is a piece of a welkom page, that personal welkoms people when the log in by there name.

SELECT M_ID, M_FIRST, M_FIRST + ' ' + M_LAST AS NAME
FROM MEMBERS
WHERE M_ID = 'MMColParam'

Why does M_First returns twice in the statement ???

And what does + ' ' + mean ??

Thanks already

It substracts DB field values. In case that M_FIRST = "Viktor" and M_LAST = "Farcic", value of NAME would be "Viktor Farcic". Query below returns Identity, First Name and Full Name. Since I haven't seen complete code, I can't tell you why is it like that.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Could someone explain the following sql-statement for me ?? This is a piece of a welkom page, that personal welkoms people when the log in by there name.

SELECT M_ID, M_FIRST, M_FIRST + ' ' + M_LAST AS NAME
FROM MEMBERS
WHERE M_ID = 'MMColParam'

Why does M_First returns twice in the statement ???

And what does + ' ' + mean ??

Thanks already
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager