Migrating to SQL Server from Access

  • Thread starter Thread starter May
  • Start date Start date
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
 
I believe this question has been successfully answered in another NG. Please
don't post a single question to multiple NGs.
 
Back
Top