on 12-10-2010 2:40 PM
Dear experts,
Could someone explain to me why a query like:
SELECT T0.[DocNum]
FROM [dbo].[ODLN] T0
WHERE T0.Comments Like '%$[ORDR.DocNum.number]%'
works and this one:
SELECT T0.[DocNum]
FROM [dbo].[ODLN] T0
WHERE T0.Comments Like '%$[$8.0.0]%'
doesn't?
The first query gives a correct DocNum (if I skipp the .number part it returns a value like N'204209' (inc. quotes) instead of just 204209).
The second query gets the same N'204209' value. If I add the .number for the last .0 I get a value like 204209,000000 which isn't what I want either.
I'm kinda lost figuring this out so any help would be appreciated.
René
Dear René,
I have tested in 2007A db. Both are working if you change the 2nd one to $[$8.0.number].
Are you sure it is not working?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.