Excludes 'Z' while giving LIKE '[A-Z]%' but works fine for all other combinations

Hai Friends!

I have a peculiar problem while using LIKE pattern match with SQL Server 2005. My requirement is to list names starting from a range of Characters (anything from a to z). If I want to list Names starting from A to Z I am giving the LIKE pattern as LIKE '[A-Z]%' but the result set contains names starting with 'A' alone. If I give '[B-Z]%' the 'B' Alone is included in the result set. For all remaining combinations (ex: '[A-Y]%') it gives correct results.

If I give '%' or 'Z%' it gives all starting with Z correctly. If I include the Z with any other alphabet it takes only the starting alphabet and excludes all remaining letters.

This problem seems to be too strange and couldn't understand why it gives wrong results!!

Any solutions? Thanks in advance

Visualcpp

Please list your specific syntax; the following works fine:

select aName
from ( select 'Alphabet' as aName
union all
select 'Zymurgy'
) a
where aName like '[A-Z]%'

-- aName
-- --
-- Alphabet
-- Zymurgy

Excel ouput

Hi All,
I have a requirement where I need to create a report book (7 reports) making
use of RS. The challenge is that the client need this in excel. A button on
the intranet must generate the excel output.
Has anyone done something like this as I can't find any docs on RS and excel
output.
1. When generating an excel file from RS does it xls keep formulas
2. Can each sheet be a different report (sheet name must be report name)
3. Limitations'
Any help appreciated!
ThanksExcel isn't a database reporting tool
Tell them to screw themselves.
-Aaron
Dewald wrote:
> Hi All,
> I have a requirement where I need to create a report book (7 reports) making
> use of RS. The challenge is that the client need this in excel. A button on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and excel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> Any help appreciated!
> Thanks|||Hi Dewald,
The known issue I know of is if you have a complex design in RS, in
Excel cells will have been merged and once that is done, the row size
will not want to expand to the appropriate (considering the text in it
would require so.)
Cheers
Dewald a =E9crit :
> Hi All,
> I have a requirement where I need to create a report book (7 reports) mak=ing
> use of RS. The challenge is that the client need this in excel. A button =on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and ex=cel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> > Any help appreciated!
> Thanks|||Hi,
Thanks for the reply
Yes,the more complex the look and feel is the less desired output you will
get in XSL.
I have managed to created XSL outputs from a hyperlink in a simple HTML page
that generates a XLS file and add different reports on seperate sheets
If anyone is interested on how to do this let me know...
I also found this site helpfull
http://msdn2.microsoft.com/en-us/library/ms156268.aspx
Thanks for the reply
Cheers
"Sébastien Richer" wrote:
> Hi Dewald,
> The known issue I know of is if you have a complex design in RS, in
> Excel cells will have been merged and once that is done, the row size
> will not want to expand to the appropriate (considering the text in it
> would require so.)
> Cheers
> Dewald a écrit :
> > Hi All,
> >
> > I have a requirement where I need to create a report book (7 reports) making
> > use of RS. The challenge is that the client need this in excel. A button on
> > the intranet must generate the excel output.
> >
> > Has anyone done something like this as I can't find any docs on RS and excel
> > output.
> >
> > 1. When generating an excel file from RS does it xls keep formulas
> > 2. Can each sheet be a different report (sheet name must be report name)
> > 3. Limitations'
> >
> > Any help appreciated!
> > Thanks
>