var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I cant find a clear answer to the syntax of concat in for SQL 2005. Can anyone help.
it's still the same old plus sign
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
I figured out what I was doing wrong. I used text as my data type for the two fields I was trying to CONCAT. So when I did First_name + ' ' + Last_name is was treating the two columns as text and the blank space as a varchar. So i would execute.
don't use the text type for such small fields as first and last names. text is for big blobs of text longer than 8000 chars. I don't know anyone with such a long name.
and in 2005, don't use text at all. use varchar(max) or nvarchar(max).
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors