If the numeric suffix is the only part of the policy number that changes,
then you can use:
WHERE PolicyNumber >= 'KD/FGH/3345/NNN/1000' and PolicyNumber <= '
KD/FGH/3345/NNN/1090'
Ben
On Tue, Apr 6, 2010 at 7:48 AM, Gino Pacitti wrote:
> Can someone help with a SQL statement to return rows...
On Apr 6, 2010, at 7:48 AM, Gino Pacitti wrote:
Can someone help with a SQL statement to return rows...
I have a field (varchar) which is used to store a PolicyNumber -
something like KD/FGH/3345/NNN/1000
They are stored sequentially and go up to KD/FGH/3345/NNN/5000
I need to select a se
Can someone help with a SQL statement to return rows...
I have a field (varchar) which is used to store a PolicyNumber -
something like KD/FGH/3345/NNN/1000
They are stored sequentially and go up to KD/FGH/3345/NNN/5000
I need to select a set that is something like KD/FGH/3345/NNN/1000 -
K
