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:
Posting Komentar