Select * From Client where LastName Like '#Trim(Name2)#%' AND FirstName Like '#Trim(Name1)#%' where (LastName Like '%#newSearchName#%' Or FirstName Like '%#newSearchName#%') OR LastName Like '%#Trim(Name1)#%' Or FirstName Like '%#Trim(Name1)#%' OR LastName Like '%#Trim(Name2)#%' Or FirstName Like '%#Trim(Name2)#%' #MarketList# Select ClientID From Client Where Gender IN ('#GenderList#')
Select ClientID From Client Where Spanish IN (#LanguageList#) Select ClientID From Clientage Where AgeID IN (#AgeList#) Select ClientID From ClientAccent Where AccentID IN (#AccentList#) Select ClientID From ClientTexture Where TextureID IN (#TextureList#) Select ClientID From ClientPitch Where PitchID IN (#PitchList#) Select ClientID From ClientMarket Where MarketID IN (#MarketList#) Select ClientID From Client Select * From Client Where ClientID IN (#CompareList#) Order By Gender desc, LastName