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,

CUSTNAME AS TenantName,

--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: dbalorenzini@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar