Using the wildcard character

ioshonowo

Hello. I am a newbie to SQL 2000
I am trying to get this command to work

Expand|Select|Wrap|Line Numbers

  
select pan, expiry_date

from dbo.pc_accounts_1_A 

where pan = '63913801008%'

It seems I am using the wrong wildcard(if that is the correct word). Please tell me what it should be.

Jim Doherty

Quote:

Originally Posted by ioshonowo

Hello. I am a newbie to SQL 2000
I am trying to get this command to work

Expand|Select|Wrap|Line Numbers

  
select pan, expiry_date

from dbo.pc_accounts_1_A 

where pan = '63913801008%'

It seems I am using the wrong wildcard(if that is the correct word). Please tell me what it should be.

select pan, expiry_date
from dbo.pc_accounts_1_A
where pan Like '63913801008%'

Jim :)

ioshonowo

Thanks it is working.

re: Using the wildcard character