Hi,
Current I am using the following statement to get the longest full name:
SELECT TOP 1 CITY FROM MYDB ORDER BY SQNCNMBR,
WHERE LEN(CITY) = (SELECT MAX(LEN(CITY)) FROM MYDB,
WHERE LEN(CITY)) > 0)
What I am trying also to add is a check for zipcode > 5
Please advice
Current I am using the following statement to get the longest full name:
SELECT TOP 1 CITY FROM MYDB ORDER BY SQNCNMBR,
WHERE LEN(CITY) = (SELECT MAX(LEN(CITY)) FROM MYDB,
WHERE LEN(CITY)) > 0)
What I am trying also to add is a check for zipcode > 5
Please advice