Create scalar function with declared variables

Question

I have a verify simple query in which I have a variable declared. I would like to create a scalar function that automatically converts whatever I write into the variable, into my finished string:

declare @name varchar(100) = 'firstnameLastname' select @name + '@email.com'

My goal is to use this function with a random string which converts it automatically into my Email String. For example:

select udfEmailConversion('RobertSequel')

and it should automatically return:

[email protected]

How can create a scalar function when I have variables declared in my query?

Gordon Linoff · Accepted Answer · 2020-02-10 20:12:36Z

1

If you are asking about how to define a function, the syntax looks like:

create function udfEmailConversion ( @base nvarchar(255) ) returns nvarchar(255) as begin return @base + '@email.com' end;

answered Feb 10, 2020 at 20:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

not_ur_avg_cookie Over a year ago

Hey Gordon! Thank you! And how would it look like if @name would be a column in a table?

Gordon Linoff Over a year ago

@not_ur_avg_cookie . . . Then you would call the function in a select query referring to that table and column.

Collectives™ on Stack Overflow

Create scalar function with declared variables

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related