sql server - Lower() In Visual Studio 2010 SQL Query Not Working. Alternatives? -
This is a deal. I have 2 databases, one is big and the data has expanded, the new and less relevant data, they both share the same product, there is only one more data. I have started a project, where I want to expand the new database to include some missing data in the old database. The problem is that the ID does not match between the database. So I have to search by names which may or may not be the only one, the questions given in the visual studio are definitely sensitive. I tested it and I'm sure. So my first thought was to do a similar search with a low function. Like this: less (like '[name1])' ('% name2%') But when I went to run it It gave me an error And Visual Studio tried to automatically change the syntax of the statement: WHERE 'lower' ([Name1]) 'less' ('% name2%') / pre> I could have promised less (right) syntax. And I do not find any option on Google anywhere or why the Visual Studio will not like it. I...