Search result that has a C and a number after the C in the Part Number Field

Question

I have a search results page that lists part numbers that engineers have to work on, but I only want part numbers displayed on the results page that have a C and then a number after the C in the part number. How do I write this in the Where statement in my CFQuery? If I write Where Part_Number Like 'C%', it lists all the parts that have anything after a C in the part number like CBT-BGA. I want it to find only part numbers like this: C4560. I also tried this: Where Part_Number Like '^C[0-9]', but this doesn't show any results. Thanks for your help.

jamie61880 · Accepted Answer

As it works without the "R", you are maybe on SQL Server. Try the following:

WHERE code LIKE 'b[0-9][0-9][0-9][0-9]|c[1-3][0-9][0-6][4-8][0-9][1-7]' 
-- matches B6942 and C280564

This actually works the best because I don't have to specify a certain number of digits after the C:

And Part_Number Like '[C][0-9]%'

BKBK · Answer

What database brand are you using? I ask because pattern-matching depends on the database brand.

For example, in MySQL, you can use the operator RLIKE for regular-expression pattern-matching:

SELECT *
FROM codeTBL
WHERE code RLIKE 'b[0-9][0-9][0-9][0-9]' -- matches B6942

Regístrese

Social Login

Bienvenido

Social Login

Escaneando el archivo en busca de virus

Este archivo no se puede descargar