Field Lenght

[Ielamrani]

Can anyone please tell me why this is not working. I am trying to see field street2 where lenght is Greater than 10.


SELECT DISTINCT dbo_PROV_MASTERS_HCVW.PROVID,
dbo_PROV_MASTERS_HCVW.LASTNAME, dbo_PROV_MASTERS_HCVW.FIRSTNAME, dbo_PROV_ADDINFO_HCVW.STREET, dbo_PROV_ADDINFO_HCVW.STREET2
FROM dbo_PROV_ADDINFO_HCVW INNER JOIN dbo_PROV_MASTERS_HCVW ON dbo_PROV_ADDINFO_HCVW.PROVID = dbo_PROV_MASTERS_HCVW.PROVID
WHERE ((("len[Street2]")>"10")


Thanks

 

[PHV]

SELECT ...
FROM ...
WHERE Len(dbo_PROV_ADDINFO_HCVW.STREET2)>10

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

Thank you PHV.
Ismail