alltrim in Foxpro means strip all leading and trailling spaces. Its like doing a Rtrim(Ltrim(desc)).
TSQL Rtrim - trims off trailling spaces
TSQL Ltrim - trims off leading spaces
However I don't beleive your query really needs to strip the leading or tailling spaces. I would just do a :
SELECT * where desc like '%oil%'