i tried:

SELECT ASCII('number') from customer...bud this returns only the ascii of the first character

select cast(number as varbinary(40)) from table ...bud this returns hex

i tied:

SELECT ASCII('number') from customer...bud this returns only the ascii of the first character

select cast(number as varbinary(40)) from table ...bud this returns hex

Yes, this is exatly what i want 🙂

Hi,

here is it:

CREATE TABLE [dbo].[customer](

[name] [varchar](50) NULL,

[number] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

the columns are varchar. i want to select both columns buth from the number column the ascii code.

Hi SSC,

Suppose that i have the following record in my table:

SqlServerCentral website is a great help for me.

Now suppose that i want to select only 2 words from it: SqlServerCentral...

Yes, good question from Arun. What then? 😉

Hi Elliot,

Thanks for replay, bud i don't see any actions with the table 'instellingen' in you code 😉

Hi V.Vivek,

Thanks for response.

However im little bit confused. You said :

select odate ,recpt.oreceiptnr,oamount from receipt recpt

What do you mean by 'from receipt recpt' ? and 'receipt' table does'nt have a...

Hi Imu92,

These are the data:

INSERT INTO receipt VALUES(1,1,1-1-2009)

INSERT INTO receipt VALUES(2,1,4-2-2009)

INSERT INTO spend VALUES(1,1,2-1-2009)

INSERT INTO spend VALUES(2,1,3-1-2009)

INSERT INTO receiptregel VALUES(1,1,10)

INSERT INTO receiptregel VALUES(2,1,10)

INSERT INTO spendregel VALUES(1,1,6)

INSERT INTO spendregel VALUES(2,1,3)

I learnd...

Hi GSquared,

Sorry if this is a dumb question, bud im a little bit confused.

I did'nt mean null, bud the number 0. Is it the same?

There most occur a exception...

Dear GSquared,

Thank you for response. Im a beginner in this and wrote some basic triggers bud can't figure out how to write this one.

It has to reject the insert and...

Dear ps,

Thank you for response.

Here some more about it:

table article:

CREATE TABLE [dbo].[article](

[oarticlenr] [int] NOT NULL,

[odescr] [varchar](500) COLLATE Latin1_General_CI_AS NULL,

[odate] [datetime] NULL CONSTRAINT [DF_article_odate] DEFAULT (getdate()),

CONSTRAINT [PK_article] PRIMARY...

Hi Dugi,

Thanks for your response.

These are the tables:

table customers has two columns:

CREATE TABLE [dbo].[customer](

[ocustomernr] [int] NOT NULL,

[onaam] [varchar](100) COLLATE Latin1_General_CI_AS NULL,

CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED

(

[ocustomernr] ASC

)WITH (PAD_INDEX ...