473,473 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Doubt with MAX function

Greetings,
Sorry if this questions is too basic. just wanna know if the max
function in db2 gives the result based on the ascii value or in
ascending order. I tried but not able to figure out the result.
Any help will be greatly appreciated

TIA

Nov 12 '05 #1
2 2159
pa***************@yahoo.co.in wrote:
Greetings,
Sorry if this questions is too basic. just wanna know if the max
function in db2 gives the result based on the ascii value or in
ascending order. I tried but not able to figure out the result.
Any help will be greatly appreciated

TIA

Depends on your collation :-)
If you use IDENTITY then the codepoint (ASCII for your run of the mill
character) rules. If you use System, then typically aA is before bB
etc..., but you can also use user defined collation or something funky
as Thai-collation in Unicode, which gets really interesting...

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
Thanx Serge. I know i can always count on you. :-)

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: SK | last post by:
Hi all, I have a doubt in C++ Templates by Nicolai M. Josuttis. On Page 17 there is a line "In general, it is a good idea not to change more than necessary when overloading function templates....
3
by: Old Monk | last post by:
Hi all, I have got a doubt in Koenig& Moo's AC++. On page 228 and 230, authors provide definitions for Core and Grad classes. Grad IS-A Core, i.e. public inheritance. What puzzles me is that...
1
by: Mohamed Fysal | last post by:
Hi , I have written a Regular DLL and derived the App class from CNDKClient class so that this DLL is used by another EXE to act as a Client to a Server Application which I developed deriving...
1
by: Srini | last post by:
I was reading the "Exceptional C++" of Herb Sutter. In an example, he mentions the following. // In some library header: namespace N { class C{}; } int operator+(int i, N::C) { return i+1; }...
5
by: Srini | last post by:
Hello all, I was going thru the GotW archives where I had a doubt in this particular item. http://www.gotw.ca/gotw/027.htm There is a mention about a subtle change to the standard in July...
38
by: edu.mvk | last post by:
Hi I am using strcpy() in my code for copying a string to another string. i am using static char arrays. for the first time it is exected correctly but the second time the control reaches...
8
by: toton | last post by:
HI, One more small doubt from today's mail. I have certain function which returns a pointer (sometimes a const pointer from a const member function). And certain member function needs reference...
4
by: sureshk | last post by:
In 'C' the signature of any function's prototype and the definiton of the function should match.But for function main may recieve the arguments or may not recieve the arguments 'It is optional'. How...
13
by: deepak | last post by:
Hi In the following function how the memory 'll be allocated. 1) Will it allocate memory for all the char's together or allocate for first char. then for int then for float and after this only...
2
priyan
by: priyan | last post by:
hi all, I am having a doubt of how to write a function for my situation. I am having two tables portfolioscrip portfolioscripdetails i have to insert into...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.