Thank you very much .. it worked

Create Table

USE [MIS]

GO

/****** Object: Table [dbo].[tbl_Student] Script Date: 04/22/2009 18:39:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_Student](

[Student_ID] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

insert data:

insert into tbl_student...

sample data is as:

table name: Student

Field Name: Stuent ID

Data in the field looks like:

1*10

11*12

1212*11

1234*11

12345*12

433444*10

-------------------

now what i want is to fetch no.s from the left side of *. as i...