<cfquery name="PasswordReset2" datasource="Database">
select * from userssms where user_name like <cfqueryparam value="#UserNameNew#" CFSQLType="CF_SQL_VARCHAR"> and email is not null
</cfquery>

    <cfif PasswordReset2.RecordCount = 0>
    <cfset resultPass = 0>
    </cfif>