Access query to SQL

[HLPCH]

I need to convert this Access query to SQL. There's no DistinctRow keyword in SQL. Could someone help me on the syntax?

UPDATE DISTINCTROW IRtest SET IRtest.[File #] = Right([File #],6);

Thanks

 

[jbenson001]

You need to construct a WHERE clause that will filter the rows that you want to UPDATE.

Jim