Sql query for string?

Question

I have a table Name tab1 there I have two field name f1 and f2.
Tab1 is like
f1 ..... f2
----------------
10 ... 9
200 ... 300
5000 ... 600
100 .... 199
1909 .... 1999
100 .... 199
1000 .... 1999
2000 .... 2787
....
......
I want to search all the field having match the 1st character of both the field.
o/p:
f1 .... f2
============
100 .... 199
1000 .... 1999
2000 .... 2787
1909 .... 1999

Can anyone tell me wht query I need to run?
Thanks a ton.

Answer 1

select f1,f2

from tab1

where SUBSTR(f1,1,1)=SUBSTR(f2,1,1)



substr is used to take a part of the whole string.

Answer 2

How is that going to work. If you're just matching the first character of both fields, then 100 could match either 199 or 1999 or 1000 could match 199 or 1999. I think your logic might be flawed.

Answer 3

select distinct f1,f2

from tab1

where left(f1, 1) = left(f2, 1)

Answer 4

You'll be able to ought to inform us what you wish to have first. All documents where field meets the criterion of . The where clause refers to the value of a subject or fields.

Answer 5

select * from tab1 where substr(f1,1,1)=substr(f2,1,1,);

Answer 6

yes