InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:53:55 GMT20http://www.sqlservercentral.com/Forums/Topic1384870-391-1.aspxThx good advice.. have a great dayU7Thu, 15 Nov 2012 05:28:48 GMTjbalbohttp://www.sqlservercentral.com/Forums/Topic1384870-391-1.aspx[quote][b]jbalbo (11/14/2012)[/b][hr]ThanksSO this works!!!Client.LName + ', ' + Client.FName + ' -' + cast(client.ID as nvarchar) as ClientName[/quote]Be very careful about using the default lengths for datatypes. When you don't specify the length you get the default size, and this can vary depending on context. I would add a length for your nvarchar. I don't know what datatype your ID is but 10 should be plenty of room. Make it smaller if you don't need that much length, or longer if needed.[code]Client.LName + ', ' + Client.FName + ' -' + cast(client.ID as nvarchar(10)) as ClientName[/code]/soapbox onAs a side note, it is often considered poor naming convention to have ID. What happens when you have two tables with a PK named ID? Something like ClientID is probably a better choice. One general rule for databases is that is usually preferred that a column name not change it's name when referenced as a foreign key. For example. If you have an Order table and the PK is ID it gets awfully confusing. You have a column with the same name in two tables but you join those tables on Order.ClientID = Client.ID where Order.ID = 8473. That just makes my head spin. If those same two table were aliased O and C the join becomes very clear (O.ClientID = C.ClientID where O.OrderID = 8473/soapbox offWed, 14 Nov 2012 14:58:42 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1384870-391-1.aspxThanksSO this works!!!Client.LName + ', ' + Client.FName + ' -' + cast(client.ID as nvarchar) as ClientNameWed, 14 Nov 2012 14:38:35 GMTjbalbohttp://www.sqlservercentral.com/Forums/Topic1384870-391-1.aspxYou need to convert the numeric value to a text value. [url]http://msdn.microsoft.com/en-us/library/ms187928.aspx[/url] Once all the data is strings you can concat to your hearts content.Wed, 14 Nov 2012 14:36:18 GMTCapnHectorhttp://www.sqlservercentral.com/Forums/Topic1384870-391-1.aspxI know this is pretty basic ...but how do I concat string and numeric?I wanted Client.LName + ', ' + Client.FName + ' -' & client.ID as ClientNamewhere client.id is numericThanksin advanceJoeWed, 14 Nov 2012 14:34:42 GMTjbalbo