Left or Length Command

[Ice Rhino]

I have a field that contains data such as 'ACB00/02'. How would I write into a function that gathers a load of data together for me a peice of code that will grab only the first 2 chars of the afore mentioned value, So the result would be in the new created colum in a temp table 'AC'.

This is to occur over 7,000 records but they are not all AC, I just want the first two from every line.

Regards

 

[SQL_Hell]

select left(field,2) from table

 

[Ice Rhino]

Thanks SQL,

Did you receive my mail the other day?

Regards

 

[SQL_Hell]

No probs mate,

Yeah I did, but I have been away for a couple of days. So I will try to have a look later on today/ tonight

 

[Ice Rhino]

Fantastic, thanks alot for that.

Will take future conversations to private mesages or email relating that topic.

Regards