mv_sivavardhan

 Profile Answers by mv_sivavardhan 

• Aug 6th, 2008

 

select * from tbl_users with(nolock)

where right(username,1)=left(username,1)

msrao226

 Profile Answers by msrao226 

• Aug 7th, 2008

 

 

select * from tbl_users with(nolock)

where substr(username,1,1)=substr(username,-1,1)

shini Gupta

 Profile Answers by shini Gupta 

• Aug 21st, 2008

 

select  * from tbl_users where username like 'char%' and username like '%char'

amitarudra

 Profile Answers by amitarudra Questions by amitarudra

• Sep 5th, 2008

 

Select emp_name from employees where emp_name like 'a%a';

me.ranjeet

 Profile Answers by me.ranjeet 

• Sep 25th, 2008

 

Select * FROM TEST WHERE SUBSTR(NAME,1,1)=SUBSTR(NAME,-1,1)

PrernaK

 Profile Answers by PrernaK 

• Dec 11th, 2008

 

Select * from emp
where upper(substr(ename,1,1)) = upper(substr(ename,-1,1))

serken

 Profile Answers by serken 

• Dec 18th, 2008

 

Negative argument for SUBSTR is not supported in standard SQL.

kgoyal15

 Profile Answers by kgoyal15 

• Feb 12th, 2009

 

SELECT     *
FROM         table_users
WHERE     (LEFT(name, 1) = SUBSTRING(name, LEN(name), LEN(name)))

gtotten

 Profile Answers by gtotten 

• May 26th, 2009

 

select * from emp where left(name, 1) = right(name, 1)

sivagarlapati

 Profile Answers by sivagarlapati Questions by sivagarlapati

• Jul 3rd, 2009

 

select emp_name from employee where emp_name like 'a%' and emp_name like '%a'

gudluck

 Profile Answers by gudluck 

• Jul 10th, 2009

 

SELECT stringval FROM tablename WHERE LEFT(s,1)=RIGHT(s,1);

sandeep549

 Profile Answers by sandeep549 

• Oct 14th, 2009

 

select * from tablename where name like 'char%char';

harish.kasu

 Profile Answers by harish.kasu 

• Nov 3rd, 2009

 

select * from emp where
substr(ename 1 1) like substr(ename -1 1)

imtiazali

 Profile Answers by imtiazali 

• Nov 25th, 2009

 

select * from emp where ename like a%a;

mohitgrade

 Profile Answers by mohitgrade 

• Nov 28th, 2009

 

Select Empname From Emp Where Left(Empname,1)=Right(Empname,1)  

mohley

 Profile Answers by mohley 

• Dec 2nd, 2009

 

select  * 

FROM TABLE_NAME 

WHERE SUBSTR(COLUMN_NAME,1,1) = SUBSTR(COLUMN_NAME,-1,1); 

godsrikanth

 Profile Answers by godsrikanth 

• Dec 3rd, 2009

 

select * from hz_parties
where ascii(substr(party_name,1,1))= ascii(substr(party_name,-1,1))

This works in Toad 10g dint try in sql plus

thanks
neo

madhuri c

 Profile Answers by madhuri c 

• Dec 8th, 2009

 

SELECT ename FROM tablename
WHERE SUBSTR(ENAME,1,1)= SUBSTR(ENAME,LENGTH(ENAME))...

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Jan 16th, 2010

 

This can be accomplished in two ways example

CREATE TABLE emp (n number,
name varchar2(30),
sal number)

INSERT into emp values (100,'abhisheka',10000)
INSERT into emp values (101,'noabhisheka',10000)

Method 1:
SELECT *
FROM emp
WHERE substr(name,1,1)=substr(name,length(name))

Method 2:
SELECT *
FROM emp
WHERE substr(name,1,1)=substr(name,-1,1)

asriyazudeen

 Profile Answers by asriyazudeen 

• Jan 20th, 2010

 

SELECT ename FROM emp WHERE substring(ename,1,1)='n' AND substring(ename,-1,1)='n'

shaileshjori

 Profile Answers by shaileshjori 

• Oct 28th, 2010

 

Following query produces the desire results

select last_name from employees where select last_name from employees where substr(lower(last_name),1,1)=substr(lower(last_name),-1,1)

hanuvalluri

 Profile Answers by hanuvalluri 

• Apr 8th, 2011

 

select * FROM emp Where upper(substr(NAME,1,1)) = upper(substr(NAME,-1,1));

i tried this and is working...


mistake in the previous answers is comma (,) is not used instead space(' ') is used.

Miao Lin

 Profile Answers by Miao Lin 

• May 9th, 2011

 

SELECT * from employee
where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Jun 8th, 2011

 

In Teradata,

sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)