|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
05-31-2007, 8:42 PM
| #1 | ||
 |
This function is supposed to strip a fixed N characters from the right, reducing "REWARDING" to "REWARD" with myterm in column C, and N = 3. Currently I have: SELECT LEFT (myterm, LENGTH(myterm)-N) from C Can this be shortened a bit? Thanks, Andreas | ||
     |
| Advertisements |
|
05-31-2007, 8:42 PM
| #2 | ||
| |
"Andreas Eibach" <aeibach@despammed.com> wrote in message news:dcg6sm$cgj$04$1@news.t-online.com... > This function is supposed to strip a fixed N characters from the right, > reducing "REWARDING" to "REWARD" with myterm in column C, and N = 3. > Currently I have: > > SELECT LEFT (myterm, LENGTH(myterm)-N) from C > > Can this be shortened a bit? > > Thanks, > > Andreas > SELECT RIGHT (myterm, N) from C ? Ron | ||
| |
|
05-31-2007, 8:42 PM
| #3 | ||
| |
"Ron" <xxx@xxx.com> wrote in message news:42ebb5f1.0@entanet... > "Andreas Eibach" <aeibach@despammed.com> wrote in message > news:dcg6sm$cgj$04$1@news.t-online.com... >> This function is supposed to strip a fixed N characters from the right, >> reducing "REWARDING" to "REWARD" with myterm in column C, and N = 3. >> Currently I have: >> >> SELECT LEFT (myterm, LENGTH(myterm)-N) from C >> >> Can this be shortened a bit? >> >> Thanks, >> >> Andreas >> > SELECT RIGHT (myterm, N) from C ? > > Ron > > That would return the string "ING". Not really what the OP wants ;-) Matthias | ||
| |
| Featured Websites | ||||
|
|
| Tags: bit, function, help, making, shorter |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Quickform: how to check two fields in one function using registerRule() | l Burnerheimerton | Pear | 1 | 05-20-2007 6:34 PM |
| call to undefined function curl_init() | Henk oegema | PHP | 1 | 05-20-2007 6:33 PM |
| Function tables | ZeldorBlat | PHP | 2 | 05-20-2007 6:33 PM |
| Function tables | Beshoo | PHP | 0 | 05-20-2007 6:33 PM |
| Basic Usage Of Php Mail Function | Whatcha | PHP | 3 | 05-11-2006 2:46 AM |
| Featured Websites | ||||
|
Please help in making this function a bit shorter 
PacMan
Linear Mode
