i dont need to change field, i have filed

CREATE FUNCTION item1(@Data [varbinary](max))

RETURNS TABLE (

item2 varchar,

item3 int)

now i need to add...

i think i will lost my job , i am on dead line

i m trying to help u as much as possible.

there is nothing in sp, sp calling udf...

it snot my design,this is how my database is working

i m just employee ,i dotn have right to change anything

so plz help

function is already created, i need to add more rows ,if i do insert into ,it wont get insert.

do i need to have update ,if so how can i update...

fine.

i am giving sample data.

i have 1 stored prc sp1,which has table values function ,so its return table.

output.

fromdate todate ...

i dont have this thread before.

yes i need to get same values in else also

i did.stil its not working

i m getting values like this

null

null

item1

null

null

how to tremove null

@ is not in sql,it just constant in my sql

will this work '@_%'

ok i need to match @% in my query ,how to do that

if i do using like '@%' its not working

i havent done anything for this ,trying to use case but doesnt work

it doesnt matter , how do i get those value in select stm

assume that it is part of item 3 ,it is not in database ,it is in application

@ stands for group

i have group name item3 ,which i am supplying in my sp.

now this group contains pen ,pencil .so in my table i have code for everything

for pen,pencil...