Re: & in the where clause
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 10/22/04
- Previous message: JIM.H.: "& in the where clause"
- In reply to: JIM.H.: "& in the where clause"
- Next in thread: Steve Kass: "Re: & in the where clause"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 23 Oct 2004 00:23:49 +0530
not sure, why do you want to do that. but if you are using "=" equal
operator for comparison then query will look for exact match in the table.
If exact match is not found then you will not retrieve any row.
either change source data or change the value that is being passed in where
clause.
you may try something as follows:
SELECT discounts.*, discounttype AS Expr1
FROM discounts
WHERE replace(discounttype, ' ', ' & ') = 'Initial & Customer'
-- Vishal Parkar vgparkar@yahoo.co.in | vgparkar@hotmail.com
- Previous message: JIM.H.: "& in the where clause"
- In reply to: JIM.H.: "& in the where clause"
- Next in thread: Steve Kass: "Re: & in the where clause"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
