A dash in an sql query

[Yevgeny Efter]

Hello! I am writing an application that works with a SQL Server database, and in the application I try to run a query which has a dash ('-') in it. Because of the dash, the query doesn't work. I guess that the .net compiler understands the dash as a special character, and sends the wrong query to SQL Server. Is it right? Or the problem is not this? How can I solve it? Thanks!

[Gareth H]

Yevgeny Efter, Post the SQL and maybe we can see why its not working. Regards, Gareth.

[Colin Angus Mackay]

Yevgeny Efter wrote:

a query which has a dash ('-') in it. Because of the dash, the query doesn't work. I guess that the .net compiler understands the dash as a special character, and sends the wrong query to SQL Server. Is it right? Or the problem is not this?

The C# compiler (.NET is the framework) will not change your query. So, no, that is not right. Most likely the SQL code supplied is not legal SQL in the first place.

Yevgeny Efter wrote:

How can I solve it?

Since we have no idea of what you have actually written it is difficult to say. There are a number of possibilities but they all depend on where this dash is and why it is there. For example, is the dash in a column or table name? If so then escape it with square brackets e.g. [my-column-name-with-dashes]

Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

[Yevgeny Efter]

Thank you! The brackets solved it.

Have a nice day!