Can anybody help me with this;
In Access I had this kind of query:
SELECT * FROM Table1 WHERE MID(Column1, 3, 2) = MID(Column2, 3, 2)
In SQL2000 the mid is not recognised...
What do I do instead?
Printable View
Can anybody help me with this;
In Access I had this kind of query:
SELECT * FROM Table1 WHERE MID(Column1, 3, 2) = MID(Column2, 3, 2)
In SQL2000 the mid is not recognised...
What do I do instead?
please advise back what this mid function is supposed to do and i might advise you back the alternative.
the problem with me now that i don't know what this mid do
:confused:
Okay, I got the MID changed by LEFT OR RIGHT,
Now problems show up with comparing a nvarchar with a float.
In Access it was just VAL(Column1) = VAL(Column2)
Column1 is text and Column2 contains an integer.
(where the text in column1 is the same as the number in column2)
The SQL2000 doesn't recognise the function VAL...
Okay, Got it.
Its CONVERT(INT, Column1) = Column2
http://www.microsoft.com/resources/d...rt2/c0561.mspx
Thanks MS
it's very nice that you have started and ended the thread yourself.
you didn't even give me a chance to help
anyway glad, u solved it out
:wave:
I'm sorry... next time I'll wait okay?