hi all,
Is this possible to check if there is a value in the parameter collection and if there is none skip from executing the next sql line. thanks
If Not IsDBNull(SqlDataSource1.SelectParameters(":VendorName")) Then
Sql = Sql & " AND (Upper(V.VNAMEL) LIKE '%' || Trim(Upper
VendorName))|| '%') "
End If
Is this possible to check if there is a value in the parameter collection and if there is none skip from executing the next sql line. thanks
If Not IsDBNull(SqlDataSource1.SelectParameters(":VendorName")) Then
Sql = Sql & " AND (Upper(V.VNAMEL) LIKE '%' || Trim(Upper
VendorName))|| '%') "End If