Parameters

[cgj]

Hi, When using Parameters in a select command for access you use,
SELECT Fname, Lname FROM Customers WHERE Lname=?

In Sql Server you use
SELECT Fname, Lname FROM Customers WHERE Lname = @Lname

Now I am using access so I use ? when upgrading to sql I will have to rewrite all of the commands not just change the connection string?

Is there a Solution?

Thanks For Your Help

[Edneeis]

Access 2000 and higher supports named parameters.

[cgj]

Thanks