Hi, I have a problem wiht a SQL Sentence, if I have got a field char(30) and this field of one table of my database have for example : "01/12/2005 10:12:25" my question is how can I do a selection if I want do a selection between 01/12/2005 to 31/12/2005 and show the result in a datagrid. I´m working with Sybase
 
I have tried: 
 
            Select * from Table where field between like "01/12/2005%" and
                                                                      like "31/12/2005%"
 
Error
 
If I try
 
            Select * from Table where field like "01/12/2005%"
 
The result is ok.
 
Any idea ?????? Any help ???? Any example ????
Thanks in advance.


"Willemse, K.F." <[EMAIL PROTECTED]> wrote:
Can't you simply write one yourself? That should not be very hard for someone who has some experience in programming...

-----------------------------

I need a function which is writing price by text
For example : 223 $ -> twohundredtwentytree dollars

Where can I find ?


------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/XGgtlB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links










Yahoo! for Good - Make a difference this year.

SPONSORED LINKS
Basic programming language C programming language Computer programming languages
Programming languages C programming language Software programming language


YAHOO! GROUPS LINKS




Reply via email to