I have table name in that I have Rajesh Reshika Priya I want the result Lik

I have table name in that I have
Rajesh
Reshika
Priya
I want the result Like only Starting with R
Rajesh
Reshika

Can someone help me to get these results and How?

Question Posted / rajeshreshi

3 Answers
5453 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with..

Answer / vamshi ch

U can do by using the expression.
Use variable var1.
Var1= IIF(SUBSTR( NAME_FIELD, 1, 1 )=R,1,0)

In Filter use the condition to filter var1=1.
Only the names starts with R will come as output.

Another way:
In source qaulifier write a query to filter the records
which starts with name 'R'.

Select * from Table where name like 'R%'

Is This Answer Correct ?

9 Yes

1 No

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with..

Answer / babu

Hi,
IF U R SOURCE IS FLAT FILE,
U CAN WRITE A FILTER CONDITION IS SUBSTR(COL1,1,1)='R'
THEN U GET ONLY COL1 STARTING VALUE IS R.

ELSE U R SOURCE IS RELATIONAL
WRITE SQL OVRRIDE IN SQ T/R
AS SELECT * FROM TAB_NAME WHERE COL1 LIKE 'R%'
THEN U GET ONLY COL1 STARTING WITH R DATA.

IF ANY THING IS WRONG CORRECT ME.

THANKS,
BABU

Is This Answer Correct ?

2 Yes

0 No

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with..

Answer / guest

SELECT * FROM TABLE NAME LIKE'R%'
OR U CAN USE SUBSTRING
SUBSTRING(RAJESH,1,1)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer