SELECT CAST(ID AS nvarchar(length of string here)) ID... Ryan On 7/25/05, Eva Li <[EMAIL PROTECTED]> wrote: > > Hello All, > > I have a SQL stored procedure that reads data out. In the query, > I have some thing like: > > SELECT ID, (ID + ' - ' + Name) AS IDName FROM Person > > Here, ID is integer and name is of type varchar. My question: > > How can I convert ID to string and make IDName as string in this query? > > Can any one help me with this? > > Thanks! > > Eva > > > [Non-text portions of this message have been removed] > > > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group > "AspNetAnyQuestionIsOk<http://groups.yahoo.com/group/AspNetAnyQuestionIsOk>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ >
-- Thank you, Ryan Olshan <asp:Web Programmer, Owner /> TeraNet Systems http://www.teranetsystems.com ----------Internet E-Mail Confidentiality Statement---------- The content of and attachment(s) to this electronic transmission are intended for the use of the person, firm or entity to which it is directed, and may contain information that is private, confidential, exempt from disclosure under applicable law, and/or proprietary to TeraNet Systems. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, please kindly destroy it and notify the sender, [EMAIL PROTECTED], immediately by reply e-mail. Thank you for your cooperation. ------------------------------------------------------------------------------- [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
