Convert Access Query to SQL Server 2005

Topic

New Reply

Hi,
I’m trying to conver this query from Access to SQL Server 2005. I can get everything by the syntax for the new column that is a combination of [username]&””&[password].

SELECT [username] & “” & [password] AS UsernamePassword, tblUsernamePassword.SecurityLevel, tblUsernamePassword.Username, tblUsernamePassword.Password, tblUsernamePassword.Active, tblUsernamePassword.EmployeeName
FROM tblUsernamePassword;

Thanks!
Leesha

Reply | Quote

Replies

Inplace of [username]&””&[password]
try
[username] + ‘ ‘ + [password]

Reply | Quote

Thanks Pat! Worked like a charm!

Leesha

Reply | Quote

Concatenating with an empty string “” has no effect, so if you really want to concatenate username and password with nothing in between, you can use

SELECT [username] + [password] AS UsernamePassword, …

Reply | Quote

Thanks Hans. I always appreciate the help. The access sql was working but if this is the right way to do it then of course that is my goal!

Leesha

Reply | Quote

SQL Server uses + instead of & to concatenate strings.

The extra “” didn’t do any harm, but it didn’t serve any purpose either. Concatenating any string with “” results in that string:

“Leesha” & “” = “Leesha”

“Woody” & “” & “Leonhard” is the same as “Woody” & “Leonhard”. Both result in “WoodyLeonhard”.

Reply | Quote