> Is there any similar statement in SQL Server for the below Oracle query
>
> SELECT ENAME FROM (SELECT ENAME FROM EMP WHERE DEPTNO = 10)
> WHERE SUBSTR(ENAME,1,4) = 'SAHU';

<sangu_rao@yahoo.co.in> wrote in message
news:1168578207.262940.268520@l53g2000cwa.googlegroups.com...
> Hi,
> Is there any similar statement in SQL Server for the below Oracle query
>
> SELECT ENAME FROM (SELECT ENAME FROM EMP WHERE DEPTNO = 10)
> WHERE SUBSTR(ENAME,1,4) = 'SAHU';
>
> The above one is a Oracle query, i want to know is there any equivalent
> query in SQL server.
> I don't want to write the query as
>
> SELECT ENAME FROM EMP WHERE DEPTNO = 10 AND SUBSTR(ENAME,1,4) = 'SAHU';
>
> Please provide your comments.
>
> Thanks
> Rao
>