Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selecting few characters from a field

Status
Not open for further replies.
wdbouk

wdbouk

Technical User
May 28, 2003
81
CA
Hello,

I have a text field with 9 characters and i want to select only the first 8 of it. I tried the following
UPDATE ISSUE SET Cusip8 =(Cusip9,8);but i received a syntax error. Any other suggestion?
thx
 
Sort by date Sort by votes
...SET Cusip8=SUBSTRING(Cusip8, 1, 8)...

or

...SET Cusip8=RIGHT(Cusip8, 8)...





Bob Boffin
 
Upvote 0 Downvote
To update value to the first 8 chars you should be using
Code: 
update issue
set    cusip8 = left(cusip8, 8)
instead of right function.

Regards,
AA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
602
bharons
bharons
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
655
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
890
SashaBuilder3
SashaBuilder3
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
600
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
429
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top