you are right, but when i chop the characters and get, how can i deal with it to insert it in the second field, please if you have idea

hoverinc
—
2011-02-03T13:59:32Z —
#6

SELECT SUBSTRING('artist_name',1,1) this is it what i was looking, now i will try to find out how to insert it into the second field, if you have any idea while mine goes well its most appreciated, with lots of thanks

But now i will do compare using where field's ID = same ID to be inserted respectively

hoverinc
—
2011-02-03T14:19:19Z —
#9

And also i want to use UPDATE instead of insert because some fields contains some data, hope if you have any suggestions, with my infinite thanks

guido2004
—
2011-02-03T14:22:42Z —
#10

UPDATE table
SET letter = SUBSTRING(field, 1, 1)

r937
—
2011-02-03T14:29:53Z —
#11

hoverinc said:

Hello everybody, I am trying to insert in the letter field the first letter of the FILEDX's content, How can i do it???

i should think that a relatively germane question is why would you want to do that?

hoverinc
—
2011-02-03T14:32:19Z —
#12

Also i have checked this one it works

SELECT LEFT(FIELD, 1)FROM TABLE

hoverinc
—
2011-02-03T14:37:35Z —
#13

UPDATE TABLESET letter = SUBSTRING(FIELD, 1, 1)where id=id2

With this we did it, same thanks to all of you guys for today we have solved our problem and we achieved our duty... thanks AGAIN

hoverinc
—
2011-02-03T15:01:48Z —
#14

guido2004 said:

UPDATE table
SET letter = SUBSTRING(field, 1, 1)

Thanks so much, that helped me lot

hoverinc
—
2011-02-03T15:03:25Z —
#15

r937 said:

i should think that a relatively germane question is why would you want to do that?

Yes because I was in a need to put that first letter in a field that was requesting the letter:)

r937
—
2011-02-03T15:17:38Z —
#16

why would you want to have a separate column containing the first letter only?

guido2004
—
2011-02-03T15:25:44Z —
#17

homework?

hoverinc
—
2011-02-03T15:50:12Z —
#18

r937 said:

why would you want to have a separate column containing the first letter only?

Well you're right, this letter appears when its categorized by letters

rguy84
—
2011-02-03T16:05:46Z —
#19

So why don't you group them by distinct values of the results dynamically. Ex: You have the results Ryan, Rudy, Guido. I am assuming you want like a a-z list. Currently you'd get R,R,G, which R, G would be cleaner.

hoverinc
—
2011-02-03T16:15:43Z —
#20

rguy84 said:

So why don't you group them by distinct values of the results dynamically. Ex: You have the results Ryan, Rudy, Guido. I am assuming you want like a a-z list. Currently you'd get R,R,G, which R, G would be cleaner.

It's not working in this manner, only this field should appear with a letter, that was the aim;)