break a colummn

[Kendel]

Hi All,

I know I can break a column's value after I get the result set but can I break it in the SQL statement. something like:

Select Left(column2,4) as first4, Right(column2,4) as last4
from ...blab ..blab

Thanks.

 

[SQLDenis]

yes

I mean, did you not try before posting here?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[Kendel]

Yes, I'd tried it. The thing is I'm now working with java/DB2, it's not the same as ASP/SQL Server. I know it's just some syntax error but I couldn't figure it out. I'm sorry for posting in the wrong room. Thank you.

 

[SQLDenis]

forum178

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[Kendel]

Thank you SQLDenis.

If anyone has ever ran into this problem, it's:

SELECT LEFT(CHAR(COLUMN NAME),5) ....