<div>
are you 200% sure that you need to pass quotes ?<br />
<br />
if yes:<br />
<br />
select * from dbo.sales_union_func &nbsp;( '''SHM''' &nbsp;)
</div>


are you 200% sure that you need to pass quotes ?

if yes:

select * from dbo.sales_union_func  ( '''SHM'''  )

<div>
I am sure but that didnt work. Any other suggestions? 
<pre><code id="code-8224528">--this returns results--

select top 1000 * from stock where assoc='SHM'</code></pre>
 &nbsp;
<pre><code id="code-8224529">--FUNCTION

CREATE function assoc_test (
    @assoc char
) returns table AS return

select top 1000 * from stock where assoc=@assoc

--QUERY
select * from assoc_test ('''SHM''')

--Does not return results</code></pre>
</div>


I am sure but that didnt work. Any other suggestions?

--this returns results--

select top 1000 * from stock where assoc='SHM'

 

--FUNCTION

CREATE function assoc_test (
    @assoc char
) returns table AS return

select top 1000 * from stock where assoc=@assoc

--QUERY
select * from assoc_test ('''SHM''')

--Does not return results

<div>
I agree, if you want to pass a string, once you define the variable as string, it's ok to pass it like shown.
</div>


I agree, if you want to pass a string, once you define the variable as string, it's ok to pass it like shown.

<div>
<div class="content wysiwyg-content">
I have a function that I need to pass a variable of 'SHM' but I cannot figure out how to get the single quotes to pass in variable. Thanks in advance. I am using SQL Server 2000.<br />
<br />
&nbsp;
<pre><code id="code-8224519">Function Query

select * from dbo.sales_union_func  
(
'SHM' -- Needs to pass as 'SHM' not SHM
 )</code></pre>
 
<pre><code id="code-8224520">CREATE function sales_union_func (

    @assoc

	
) returns table AS return


select * from stock where assoc=@assoc</code></pre>
</div>
</div>


I have a function that I need to pass a variable of 'SHM' but I cannot figure out how to get the single quotes to pass in variable. Thanks in advance. I am using SQL Server 2000.

  

SQL Function variable quote passing

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.