Deleting data from beginning of table

[Mat]

I want to delete some numbers from a field in the
beginning of a table (eg 012 abcdefg, etc) There will be
loads of these numbers so I want to do it in code. The
actual number of digits will only ever be 3 max -
eg "012". Can anyone help ?

 

[Duane Hookom]

Please take the time and effort to enter about 6-10 records and an example
of how you want your result.

 

[Rebecca Riordan]

Check the Left() function; it may do what you need, but you'll need to tell
us the rules for determining what to throw away and what to keep if you need
more specific help.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...