Using PATINDEX/CHARINDEX from a table of rules

Question

Using PATINDEX/CHARINDEX from a table of rules

Sherlan Emmanuel Burgonia 86

Hi I have been working with search patterns from this PTEST table
and I would like to know is there a way that I can use this table instead of hardcoding each to my script?

SELECT   
	CARNUMCOD,  
	TicketedFareBasis,  
	TourCode,  
	ExpandedFB,  
	ExpandedFB2,  
	PATINDEX(PTEST, ExpandedFB) AS TEST  
FROM EDW_ASB.RAPID_FareBasis

NikoXu-msft 1,916 Reputation points

2022-10-18T07:44:58.84+00:00

Hi @Sherlan Emmanuel Burgonia ,

It would certainly help if you posted CREATE TABLE statements for your tables and the INSERT statements with sample data. Then it would be easier to understand what you are doing and what you trying to achieve.
SSingh-MSFT 16,461 Reputation points Moderator

2022-10-19T05:36:59.907+00:00

Hi @Sherlan Emmanuel Burgonia ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

1 answer

Your answer

NikoXu-msft 1,916 Reputation points

2022-10-18T07:44:58.84+00:00

Hi @Sherlan Emmanuel Burgonia ,

It would certainly help if you posted CREATE TABLE statements for your tables and the INSERT statements with sample data. Then it would be easier to understand what you are doing and what you trying to achieve.
SSingh-MSFT 16,461 Reputation points Moderator

2022-10-19T05:36:59.907+00:00

Hi @Sherlan Emmanuel Burgonia ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Erland Sommarskog 128.9K MVP Volunteer Moderator

As Niko says, it is not clear what you are looking for. But if you want to find rows which matches any of the patterns:

   SELECT *  
   FROM  tbl t  
   WHERE EXISTS (SELECT *  
                       FROM  @patterns p   
                       WHERE t.ExpandedFB LIKE t.pattern)

Share via

Using PATINDEX/CHARINDEX from a table of rules

1 answer

Your answer