Partial Number Search

Shinto · #1 (**permalink**) 04-07-04, 01:36

I have the following table and columns.

Account

AccountNo(Integer) AccountID(VarChar)
----------------------------------------------------
0134707 John
0134570 Perry
0134752 Koala

Is there any SQL query for me to select AccountNos which begin with '0134'? i tried using the Select * from account where accountno = %0134% but it didnt work. Thanks for your help

RKrick · #2 (**permalink**) 04-07-04, 02:11

You must check with

WHERE accountno LIKE '0134%'

J Petruk · #3 (**permalink**) 04-07-04, 08:09

Quote:

Originally posted by RKrick
You must check with

WHERE accountno LIKE '0134%'

You need to cast it though... it's an INTEGER.

WHERE char(accountno) LIKE '01234%'

r937 · #4 (**permalink**) 04-07-04, 08:24

if accountno were really an integer, would it have those leading zeroes?

J Petruk · #5 (**permalink**) 04-07-04, 08:32

Quote:

Originally posted by r937
if accountno were really an integer, would it have those leading zeroes?

But if it isn't, then would he have put (Integer) next to the column name?

We'll never know!

n_i · #6 (**permalink**) 04-07-04, 09:18

Quote:

Originally posted by J Petruk
But if it isn't, then would he have put (Integer) next to the column name?

We'll never know!

..and if it really is an integer I believe it might be more efficient to search for 'ACCOUNTNO BETWEEN 134000 AND 134999'

r937 · #7 (**permalink**) 04-07-04, 09:34

what is it with all the toronto people posting in this thread???

where's HomerBoo?

we should start our own local database club, eh

Internet Services

Web Development

Digital Marketing

Consumer Tech