Ask a SQL query for fuzzy queries

dotbuff

The function I implemented is this:
There are two types in total. The first type is, for example, that I want to find a record with a hundred-digit number 1 in the table. It must be in the hundred-digits and one. The database table itself contains three-digit records. The result is something like 135,178,176,1 **.
The other type is not divided into digits, as long as one of the three digits is eligible
For example: 178,651,216, etc.

siyonggang

1. select * from tb1 where (column1-100) between 0 and 99

2.SELECT *
FROM tb1
WHERE (CAST (column1 AS varchar) LIKE '% 1%')

dotbuff

r can't understand (column1-100) What does this mean?
There is also this CAST (column1 AS varchar)? Conversion?

siyonggang

column1 is the name of that column, I do n’t know your column name, so use column1 instead
1. What I said is that the condition I choose is that the number of column1-100 is between 0 and 99, that is, the hundreds place is 1.

2CAST (column1 AS varchar) This is a type conversion. I guess your database column should be a numeric type. We need to convert it into a character type. You need to convert it to a character type first, and then see if there is a 1 This character

Specifically, look at your t-sql online help. There are related examples above.

四不像君

The first question on the third floor is wrong, it should not be between 100 and 99
The landlord said that the thousandth is only 1. The number does not mean that the thousandth is over.
use:
where mid (right (cast column1 as nvarchar, 3), 1,1) = ‘1’
Write it like this!