Search results for query: *

I am trying to obtain the longest full name with a zip+4 SELECT TOP 1 * FROM waynedb ORDER BY FULLNAME WHERE LEN(RTRIM(FULLNAME)) = (SELECT MAX(LEN(RTRIM(FULLNAME))) FROM waynedb WHERE LEN(RTRIM(FULLNAME)) > 0 AND LEN(RTRIM(ZIP4)) > 9) I am receiving records without zip+4

I have the following SQL statement. What I am trying to do is find the longest length address that has a zip+4. I know there may be many address that have the same length. My problem is I am getting addresses that do not have a zip+4. Any help would be greatly appreciated: SELECT TOP 1...

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

I am having 2 minor problems, first, I can't open an excel workbook: oExcel = CreateObject("Excel.Application") oWorkbook = oExcel.Workbooks.Open("C:\WDPQA.xls") I have even tried oWorkbook = oExcel.Application.Workbooks.Open("C:\WDPQA.xls") The funny thing is I will comment out the oWorkbook...