Selasa, 29 Maret 2016

[MS_AccessPros] SQL to Acces SQL


Can someone help me translate this from T-SQL to Access SQL:

select custnmbr AS CustID, custclas AS Class, ADRSCODE AS UnitID,Hold,

LTRIM(RTRIM(SUBSTRING(CustName, 0, CHARINDEX(',', Custname)))) As LastName,


--LTRIM(RTRIM(SUBSTRING(CustName, CHARINDEX(',', CustName)+1, 8000)))As FirstName,

address1, address2, city, state, zip from RM00101

where INACTIVE = 0 and city <> ' ' AND CUSTCLAS='Rental' and Hold = 0

order by ADRSCODE ,  LastName

I am sure there is probably a tool that could help?

Thank you,

Art Lorenzini

Sioux Falls SD


Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)



Tidak ada komentar:

Posting Komentar