Converting the 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

 

[Meleagant]

What's your where clause?

Update IRTest Set
IRTest.[File#] = Right([File#], 6)
Where
????

Journeyman -- The Order of the Seekers of Truth and Penitence