Narasiman nar

Narasiman nar

  • NA
  • 64
  • 20.2k

in my select query shows errors

May 22 2018 12:28 AM
  i create one function string split. i am calling that function  in below select query.
 
 My function name is dbo.StringSplits
 
SELECT   [dbo.StringSplits](A.farm_detailsdata),A.farmer_id,A.farmer_season,A.farm_visitno
FROM dbo.tbl_farmer_farmdetails A
INNER JOIN dbo.tbl_farmerregistration  B ON B.farmerctscode = A.farmer_id
 WHERE B.farmerseason = '2018'
 
When i execute the above query shows error as follows
 
Incorrect syntax near 'A'.
 
what is mistake in my above query. please help  me.

Answers (15)