Re: create 'list' of string matches for "LIKE" criteria

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 15:30:28 +0200

Thanks Anith (an all). I guess I felt that as SQL Server allow an alias or an expression, it would be natural
for it to allow an expression on an alias... :-) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anith Sen" <anith@bizdatasolutions.com> wrote in message news:%23vrY1zVeEHA.556@tk2msftngp13.phx.gbl...
> Tibor,
>
> >> For some reason, the first commented query didn't run...
>
> I think it is a known issue that ORDER BY clause allows expressions or
> aliases, but not expressions on aliases. Not sure if this is documented
> anywhere or not.
>
> -- 
> Anith
>
>

Relevant Pages

  • Re: Query to return 2 different names in same record
    ... Does this stop the orderby, groupby, or where clause from working? ... But you do need to keep using the aliases instead of the table names ... more do need an alias to seperate the "versions"). ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
    (microsoft.public.sqlserver.mseq)
  • Re: Help w/SQL
    ... I think you might be thinking of how SQL Server ... you can refer to an alias in an expression ... SELECT clause. ... SQL Server only considers aliases at the end ...
    (microsoft.public.access.queries)
  • Re: Query to return 2 different names in same record
    ... But you do need to keep using the aliases instead of the table names ... more do need an alias to seperate the "versions"). ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
    (microsoft.public.sqlserver.mseq)
  • Re: How to retrieve stored procedure error code in C#?
    ... Mark and William - thx for the replies, as they pointed me in the right ... > All Sql Server stored procedures have a return value parameter, ... > Please do not send email directly to this alias. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Merge Replication using ip address to distributor/publisher
    ... is no enterprize manager or client network utility. ... I also read that alias to ip address can be programmed in subscriber ... register the Publisher in Client Network Utility." ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)