SQL Character

  • Thread starter Thread starter Maik Richter
  • Start date Start date
M

Maik Richter

Hi guys,

I got a column with 10 numbers, but I only need the first 5..
Which SQL-command I should use, to convert the 10 numbers
into 5. I just need to cut the last 5.

Thank you..
Maik
 
Hi guys,

I got a column with 10 numbers, but I only need the first 5..
Which SQL-command I should use, to convert the 10 numbers
into 5. I just need to cut the last 5.

Thank you..
Maik
Click to expand...

If you only want the first five number's then:
Left(FieldName],5)
should give that to you.
 
Back
Top