Re: [Microsofts_C_Sharp] Problem with SQL Sentence !!!!!

[geme_ 3030]

Hi

i didn't try this idea but u can make every condition in a different sqlcommand

coz u can't use ||

Just try

            Geme

Alfonso Pérez Arrazubi <[EMAIL PROTECTED]> wrote:

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! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping

---

YAHOO! GROUPS LINKS

•  Visit your group "Microsofts_C_Sharp" on the web.
   
•  To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---