You are here: Re: Using LIKE in a CASE statement « MsSQL Server « IT news, forums, messages
Re: Using LIKE in a CASE statement

Posted by alberto.estrada1 on 02/04/07 07:55

On Feb 3, 2:19 pm, "--CELKO--" <jcelko...@earthlink.net> wrote:
> >> I have a unique situation. <<
>
> Probably not!! Trust me!
>
> >> My data looks something like: <<
>
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, data types, etc. in
> your schema are. Sample data is also a good idea, along with clear
> specifications. It is very hard to debug code when you do not let us
> see it.

Thanks Erland, your solution did it. I don't understand how the
second part of the syntax: SELECT DISTINCT 'Metals'
FROM MYSAMPLES

shows up as 'METALS'. I thought i would have had to select an AS
somewhere...nonetheless it worked!!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация