Sql server does not support the syntax of mysql concat,. Is there any alternative method?

problem description

to implement a multi-field fuzzy query, check the syntax of CONCAT (field 1, field 2, field 3) like in mysql, but sql server does not support this syntax. Ask if there is any way to implement multi-field fuzzy query

the environmental background of the problems and what methods you have tried

the syntax of select * from table where field 1 + field 2 + field 3 like can be found on the Internet, but it is found that if the fuzzy field has a number, the query record will be incomplete.

it is found that the record of fuzzy query phone number with 7 will be missing. I hope God will give me an answer

Sqlserver mysql

Mar.28,2022

Previous: `{ []} `and `uploch` are the codes of what framework of PHP?

Next: Html clicks the button on a row of tables to get the details of the data returned by the background of that row.

What is stored in the database is the html code, how to blur the contents of the query tag?
what is stored in the database is the html code, which is mainly a piece of div content, including the style, does not contain the body and other tags, and the label is strict in opening and closing. If I want to query the keyword "class " now, if I us...

Oracle sqlserver mysql java php

Mar.03,2021
Invalid ORA-01722: number, the field type of both tables is varchar (2)?
when writing insert sql statements with python + cx_oracle, the error message is an invalid ORA-01722: number. The field types of the two tables are the same, and they are executed in PL SQL, and the field that reported the error is found. But after loo...

Sqlserver mysql oracle

Mar.05,2021
Mysql queries whether there is a value in multiple fields
if the picture is a table, how to find the data equal to 8 in the three fields of mobile1 or mobile2 or mobile3 although you can use where or, ask God how to write sql statements if you don t use where or. Ask for advice ...

Sql sqlserver mysql

Mar.05,2021
What tools or ways do mysql and sql server have to check the number of times sql executes?
or answer my question directly: when a sql of select has a primary key and an index, what is the order of its execution? is there a big god to find it first from the primary key or from the index? ...

Index primary-key sqlserver mysql database

May.22,2021
How to return the number of records that meet the query criteria before paging in a paging query?
how to check the total number of records returned by answering query conditions in query pagination: select top 10 * from (select row_number() over(order by id asc) as rownumber,* from com_system_menu) temp_row where rownumber>((2-1)*10); the nu...

Postgresql sqlserver mysql sql

Jun.13,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e7087a-2e4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e7087a-2e4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?