Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 TSQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-27 : 10:19:53
Shahzad writes "Hello All

My Query is like that

Select PostCode From tb_Postcode.

Now in PostCode field values would be e.g N17 7ES or SL2 2QD. But I only want first character part of it. In first case only N in second case I only need SL to be selected.

Pls help out of this crap.

Thx in advance."
   

- Advertisement -