I needed a char representation of a GUID field but couldn't retrieve it because of an obscure error :-s
Insufficient result space to convert uniqueidentifier value to char.
This was caused by a CAST as varchar without specifying the length (or a too short length).
Just using CAST(field as char(36)) solved the problem.
Subscribe to:
Post Comments (Atom)
2 comments:
Thanks!
saved me ages looking :)
You are most welcome ;-)
Post a Comment