CONVERT(nvarchar, DescriptionId) will do it I think, but this will not make it anymore meaningful
On Saturday, March 17, 2012, Stephen Russell <[email protected]> wrote: > On Thu, Mar 15, 2012 at 8:41 AM, Denice Bollinger > <[email protected]> wrote: >> Good morning everyone. >> >> I hoping you can help me figure out something in SQL. I am very new to >> SQL and I need to convert a field that is unicode into something >> meaningful for example: >> >> The column id is DescriptionID and the data in the field looks like >> 021F58E0-493E-4E36-9317-DFFC3EC0244D, is there a way to convert this >> to string. > --------------------- > > This is probably a GUID / Uniqueidentifier in SQL Server. > > It is a Key, nothing more. > > > > -- > Stephen Russell > > 901.246-0159 cell > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
