Simple Query

Question

Simple Query

raj-247939

SSCertifiable

Points: 5999
More actions
March 14, 2006 at 3:23 am

#116433

Dear all ,

i have records like this
1-E02162/06
2-E02162/06
E-02162/06
2-E02162/06

i nead the record which is E-02162/06

how can i do this

from
Killer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Vladan SSC-Insane Points: 22072 More actions · Answer 1

SELECT * FROM your_table where your_column = 'E-02162/06'

I suppose that this is not what you asked for, but I can hardly help you unless you describe what you need - that is, WHY you need the row you mentioned. Because it begins with E? Because it begins with a letter? Because it is shorter than the rest? Because the rows are ordered and this row should be displayed as last? Or do you want to show all rows that don't match certain pattern... if so, what is the pattern?

In addition, DLL (table definition in form of CREATE TABLE) and some sample data (INSERT INTO... VALUES) would be very helpful.

raj-247939 SSCertifiable Points: 5999 More actions · Answer 2

hi.

this is not what i need.

i need a query that will give me the record starting with E.

from

killer

jim Edwards-308192 Say Hey Kid Points: 680 More actions · Answer 3

select * from table

where <field_name> like 'E%'

try that

AMIT GUPTA-263376 SSCarpal Tunnel Points: 4244 More actions · Answer 4

You Can use Either :

select * from <tablename> where left(col_name,1)='E'

It will display to you all the records starting from 'e'

OR

select * from <tablename> where col_name like 'E%'

Both will provide to Same Result.