A
Arch
The following code is from Access and I am migrating all
the queries to SQL server. Please help me convert this
String Concatenation along with a column name of a table
to SQL server. Once I transferred the query into the SQL
Query Analyzer, I tried replacing a dot for ! mark and +
sign for &. But it still comes up with an error. It looks
for a column name called Project Awarded and says 'invalid
column name'. It does not read the string as text.
CREATE VIEW [Projects Awarded] AS
SELECT Mun_Code_Name.County, "Project Awarded " & [Award]!
[AwardDate] & ". " AS Remarks2, Award.CloseOutStatus
FROM .......etc.
Any help regarding this will be appreciated very much.
Thanks
Arch
the queries to SQL server. Please help me convert this
String Concatenation along with a column name of a table
to SQL server. Once I transferred the query into the SQL
Query Analyzer, I tried replacing a dot for ! mark and +
sign for &. But it still comes up with an error. It looks
for a column name called Project Awarded and says 'invalid
column name'. It does not read the string as text.
CREATE VIEW [Projects Awarded] AS
SELECT Mun_Code_Name.County, "Project Awarded " & [Award]!
[AwardDate] & ". " AS Remarks2, Award.CloseOutStatus
FROM .......etc.
Any help regarding this will be appreciated very much.
Thanks
Arch