SQL Conversion Tool

[PaulSpell]

Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend

 

[WayneRyan]

Paul,

I don't know of any tools offhand. T-SQL is quite different that Jet's SQL.
The wildcard character is different (%, *), functions are different (Convert,
GetDate(), CharIndex, ...), and T-SQL can take advantage of things like
nested Selects (which Jet hates).

You can use the Query Analyzer, paste in the old Access queries, and modify
each query pretty easily.

Just some thoughts,
Wayne

 

[PaulSpell]

Thanks for your reply, I was just hoping there was an easy way of converting the SQL. Looks like it's going to have to be a case of going through this manually though. thanks anyway!