Zenith,
> Qry = "Select * from Table Where A1 Like '%' AND A2 Like '%' AND A3 Like '%' > AND A4 Like '%' AND A5 Like '%'" > > But in spite of I need a SQL sentence with four (04) AND's in its Where > clause, my SQL compiler only allow me using one AND. > > So How can I solve such a problem. This is not a PostgreSQL problem, it is a problem with whatever program you're using. Use different database tools, or access PostgreSQL directly through PSQL. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
