Where in SQL

[chipsworld]

Was wondering how I can use a Where statement in a SQL qry

Am doing a mail merge, and trying to avoid the rows in the Name column that only contain a function that returns ""

SQLStatement:="SELECT * FROM `" & wsName & "$`", SQLStatement1:=""

 

[ranman256]

sSql = "select * from table where [field]='" & sValu & "'"

 

[chipsworld]

ranman256... Ok, so I am a little confused...The wsname is a variable for the sheet and column. Not sure what the"$'" is all about, but it has always been there before...is that where I should place the Where statement? Also...I am guessing that the "Where" statement should be "Where wsName is > """...correct? First time doing this... Trying to skip cells that contain a function that is returning "" since there is no source data.

So.... SQLStatement:="SELECT * FROM `" & wsName & "Where wsName is >""", SQLStatement1:="" or like this: SQLStatement:="SELECT * FROM `" & wsName & "$`", & "Where wsName is >""", SQLStatement1:=""

 

[chipsworld]

Is there a way to just merge based on a print area? Maybe that path would yield what I am looking for.