473,394 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

pick out characters

jamesd0142
469 256MB
hi i have a string in a column and want to pick out the end of it...

col02 = "d 149 rows (ou£"
how can i find the last 2 characters?
Oct 22 '07 #1
3 1256
Jim Doherty
897 Expert 512MB
hi i have a string in a column and want to pick out the end of it...

col02 = "d 149 rows (ou£"
how can i find the last 2 characters?

SELECT RIGHT(Col02,2)

Jim :)
Oct 22 '07 #2
jamesd0142
469 256MB
SELECT RIGHT(Col02,2)

Jim :)
could i nag u again, what i need to do is pick out the values in col02 where the last two characters are not " £"

so i tried
Expand|Select|Wrap|Line Numbers
  1. select * 
  2. from temp2
  3. where (right(col02,2) <> ' £')
  4.  
is this correct because i get this "'nvalid object name 'temp2'." even tho temp has the values it should.
Oct 22 '07 #3
Jim Doherty
897 Expert 512MB
could i nag u again, what i need to do is pick out the values in col02 where the last two characters are not " £"

so i tried
Expand|Select|Wrap|Line Numbers
  1. select * 
  2. from temp2
  3. where (right(col02,2) <> ' £')
  4.  
is this correct because i get this "'nvalid object name 'temp2'." even tho temp has the values it should.
your syntax is correct for a table called temp2 and should retrieve values accordingly
Oct 22 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

17
by: Pikkel | last post by:
i'm looking for a way to replace special characters with characters without accents, cedilles, etc.
0
by: Scott Holmes | last post by:
I'm at a point in developing a user interface where I need to provide functionality for picking a date and for picking start and stop times for events. I've only done a brief google and found...
2
by: dave | last post by:
Hi there I wanna write asp code to pick up *.MAI from particular folder and read them. There is no problem with reading the file but how can I pick up the latest file from particular folder? Any...
3
by: Jules | last post by:
I've searched high and low for a 3 digit number generator that will pick at random a number between 000 and 999. The only things I have found were generators that pick numbers from 0 to 999. ...
5
by: Gary Mayor | last post by:
Hi, If I have the ' character within the javascript:pick command it doesn't work. Is there some sort of way of escaping these characters like in server side languages. function pick(symbol) {...
4
by: Max | last post by:
I'm using StreamReader.ReadToEnd() to populate and string from a file and then display it as a literal on my web site. The problem is I'm losing all the special characters like Æ,Ø, and Å that...
10
by: Mark Winter | last post by:
Hello, I am wondering if someone could point me in the right direction to figure out how to create a dynamic form. I have been developing programs in perl and oracle and have recently switched...
0
by: U S Contractors Offering Service A Non-profit | last post by:
ALOT of them to pick from... Inbox Reply Craig Somerford to uscosoct24, Matthew, B-eing-I-nstru., Ed, me, New, mw, Natural, (bcc:USA), (bcc:Letters), (bcc:lvargas), (bcc:Le), (bcc:staff),...
16
by: lak | last post by:
i know left and right shift normally,but i cant know what happens if it is negative. for example int x=-2; x<<=1;//what happens here
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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...

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.