Showing posts with label cast as varchar. Show all posts
Showing posts with label cast as varchar. Show all posts

Thursday, July 16, 2009

Cast as varchar

I always get the parentheses in the wrong order and then have to look this up!

ProviderKey = cast(GroupID as varchar)
+'-'+cast(BillingID as varchar)
+'-'+cast(LocationID as varchar)
+'-'+cast(UserID as varchar)