ColdFusion/MSSQL – new line and LIKE


SELECT id, ownership
					FROM tbl_test
					WHERE 

				lang = <cfqueryparam cfsqltype="cf_sql_char" maxlength="2" value="en">
				and 

				(
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like <cfqueryparam value="%#reReplace(arguments.real_beneficiaries, "[\r\n]", "", "all")#%" cfsqltype="cf_sql_nvarchar">
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like <cfqueryparam value="#reReplace(arguments.real_beneficiaries, "[\r\n]", "", "all")#%" cfsqltype="cf_sql_nvarchar">
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like <cfqueryparam value="%#reReplace(arguments.real_beneficiaries, "[\r\n]", "", "all")#" cfsqltype="cf_sql_nvarchar">
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') = <cfqueryparam value="#reReplace(arguments.real_beneficiaries, "[\r\n]", "", "all")#" cfsqltype="cf_sql_nvarchar">

					)
This entry was posted on Tuesday, March 24th, 2026 at 12:52 pmand is filed under Coldfusion, MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.