Migrating to SQL Server from Access

M

May

I am converting all my Access Queries to SQL Server.
Following is a String Concatenation, a part of the query I
am trying to migrate. Please help me convert this into SQL
Server. I did take the SQL from Access and paste it in SQL
Query Analyzer. I replaced the ! mark with a dot and the &
with a + sign. But it still comes up with errors. It
basically assumes the string to be a column and looks for
it and says "Invalid Column Name". Please help me with
this query:

CREATE VIEW [Projects Awarded] AS
SELECT Award.ContractAmount, "Project Awarded " & [Award]!
[AwardDate] & ". " AS Remarks2, Award.CloseOutStatus
FROM ...........

I appreciate any and all the help I can get.
Thank You
May
 
D

Duane Hookom

I believe this question has been successfully answered in another NG. Please
don't post a single question to multiple NGs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrating Access Queries to SQL Server 4
Migrating MS Access database to SQL Server 1
Query on SQL Server is fast, while Access is crawling 2
query links to SQL server and mdb table 1
Access 2010 append query to SQL is very slow 0
SQL Server SQL to Access 2003 4
Append query in Access to SQL Server 2
Query not working for SQL Server 2

Top