Re: SQL works in Access but not in SQL Server 2000 ! Why?
This is a discussion on Re: SQL works in Access but not in SQL Server 2000 ! Why? within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi & is not a valid operator to concatenate strings. Try using + John "Learning" <question_asp@yahoo.com> wrote in message ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:11 PM
| ||||
| ||||
 Re: SQL works in Access but not in SQL Server 2000 ! Why? Hi & is not a valid operator to concatenate strings. Try using + John "Learning" <question_asp@yahoo.com> wrote in message news:99a92f8.0307191244.1ce72a90@posting.google.co m... > I am new to MS SQL Server. I have SELECT statement which works fine > using Access 2000 but when I try to use this in SQL Server 2000 I get > error. > > Statement works fine in Access 2000: > > SELECT Field1, Field2 > FROM Table > WHERE Field1 & Field2 LIKE '%keyword1%' AND Field1 & Field2 LIKE > '%keyword2%' > > Error I get using SQL Server 2000: > > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for > data type. Operator equals boolean AND, type equals float. > > Does anyone know how to fix this? I would really appreciate your help.      |
|
02-28-2008, 06:12 PM
| ||||
| ||||
| Re: SQL works in Access but not in SQL Server 2000 ! Why? "John Bell" <jbellnewsposts@hotmail.com> wrote in message news:<3f19d003$0$2870$afc38c87@news.easynet.co.uk> ... > Hi > > & is not a valid operator to concatenate strings. Try using + > > John > > > "Learning" <question_asp@yahoo.com> wrote in message > news:99a92f8.0307191244.1ce72a90@posting.google.co m... > > I am new to MS SQL Server. I have SELECT statement which works fine > > using Access 2000 but when I try to use this in SQL Server 2000 I get > > error. > > > > Statement works fine in Access 2000: > > > > SELECT Field1, Field2 > > FROM Table > > WHERE Field1 & Field2 LIKE '%keyword1%' AND Field1 & Field2 LIKE > > '%keyword2%' > > > > Error I get using SQL Server 2000: > > > > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for > > data type. Operator equals boolean AND, type equals float. > > > > Does anyone know how to fix this? I would really appreciate your help. Thanks that works fine. |
Linear Mode
