We will be eventually upgrading from Access to SQLserver but right now I have an application written for access and the client needs it converted to work on SQL-server. Is there any applications that can validate the sql statement to confirm they are validate? I don't have access to SQL-server to test anything out. This is the query statement I'm trying to convert to SQL-server 7.0: SELECT NAME,POLE,LOCATION,ADDRESS_1,ADDRESS_2,MBRSEP,METER FROM PORSCHFL WHERE NAME LIKE "Anypole%" ORDER BY NAME Thanks for any help. Dave Bosky HTC Web Application Developer 843.369.8613 [EMAIL PROTECTED] ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

