Skip to Content
0
Nov 26, 2018 at 07:13 AM

where condition in user-defined-prompts-in-sap-business-one

127 Views

Hi Experts ,
Need help in parameter passing for query,.
how to use Where condition, Query is as below

/*Parameter Area*/

/* SELECT FROM [dbo].[NNM1] T1 */DECLARE @Str As nvarchar/* WHERE */SET @Str = /* T1.BeginStr */ '[%2]'

I want condition ' Indicator >='2018' '

Regards,
Swapnil Dhanwai