SELECT * FROM bar WHERE replace(City,' ','') LIKE replace('#location#',' ','') OR replace(City,' ','') LIKE replace('#location2#',' ','') ORDER by Name ASC SELECT * FROM bar WHERE City LIKE '%#Trim(textfield)#%' OR Name LIKE '%#Trim(textfield)#%' OR Phone LIKE '%#Trim(textfield)#%' OR Food LIKE '%#Trim(textfield)#%' OR Comments LIKE '%#Trim(textfield)#%' ORDER by Name ASC SELECT * FROM bar WHERE name LIKE '[#sort#]%' ORDER by Name ASC

Los Angeles Hollywood West Hollywood Los Feliz & Silverlake Midtown & Downtown The Valley Venice & Santa Monica West LA Other Locations New York Uptown Midtown Westside Villages Lower East Side NOHO & Union Square SOHO & Tribeca Williamsburg |||||||||||A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z|0-9||||||||||  #location# #Trim(Name)# Food #Trim(Food)# #Trim(Street_Address)# Happy Hour #Trim(Happy_Hour)# #Phone# Cover Charge #Trim(Cover_Charge)# >[Map] >[#Trim(Replace(Website,'http://',''))#] Live Bands #Trim(Live_Bands)# "#Trim(Comments)#"   © 2001-2004 | schneider | bowman | | rothkamm | Login