actually, while i'm here, why do i have a delete button available on this forum for the posts of other people? if i click to delete someone elses posts will...

sorry, you must have read my post before i edited it. my previous post on here is correctly showing as a convert to decimal now.

can you convert it to decimal?

'price' = convert(decimal(18,5),field1)

this works for me:

select

x.*,

y.*

from

(select

'Great Britain' as name

union

select

'angola'

union

select

'USA')x

inner join

(select

'team great britain' as name

union

select

'usa all stars'

union

select

'angola black antelopes'

)y

ON x.name like '%' + x.name + '%'

if i did:

ON x.name like '%' +...

select

x.col1,

x.col2,

'col3' = col1 + col2

from

(select

'col1' = 1 ,

'col2' = 4 ) x

does he mean something like @@identity as well?

thanks! although i'm not sure whethre thats a good...

Grant Fritchey (4/7/2009)

davidandrews13 (4/7/2009)

oh i understand why 'where col1 like 'null%' doesn't work .:) presuming thats the bit your replying to?

i was just shocked that 'where col1 not like 'null%'...

Grant Fritchey (4/7/2009)

davidandrews13 (4/7/2009)

surprisingly, for me it does seem to work.

i just did...

surprisingly, for me it does seem to work.

i just did a simple select...

i code in VB.net and i'm relatively new to using SQL, only doing it for about 1 and a half years, so i have to admit that i dont have...

just a comment on the bit about feeling like your baby sitting, leading people to the answers.

i'm the sort of person that does like to do my own homework and...

http://www.java2s.com/Code/SQLServer/Date-Timezone/Formatdatemmddyyyy.htm

there's a few examples at the bottom.

as long as you realise that if you sort by these dates it sorts as a string and not a date.

you

el_wise (3/18/2009)

I've got an SP that looks like this:

CREATE PROCEDURE USPDeleteAnswers

@Id varchar(50),

@QuestionId varchar(100)

AS

BEGIN

DECLARE @sql nvarchar(255)

SET @sql = 'DELETE FROM tblUserAnswer where Id = @Id$ and...