Between & And Clarification
This is a discussion on Between & And Clarification within the Database Support forums, part of the Web Development category; select ename from emp where ename between 'James' and 'Ward' order by ename select ename from emp where ename between '...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
08-08-2007, 01:11 AM
| |||
| |||
 Between & And Clarification select ename from emp where ename between 'James' and 'Ward' order by ename select ename from emp where ename between 'JAMES' and 'WARD' order by ename select ename from emp where ename between 'J' and 'W' order by ename Each of these queries retreive different no. of rows. Can anybody clear this out?     |
| Sponsored Links |
|
08-08-2007, 05:01 AM
| |||
| |||
 Re: Between & And Clarification Yes obviously it will return recordset based on the value given in between, did ur data has same values with different case sensitive like James, JAMES, JAm,...
__________________ -Murali.. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT -7. The time now is 04:42 AM.
