[Solved] Validate Length of Parameter using LEN function in SQL Server

tsakumar...

SOLVED CLOSED ACTIVE ANSWERED
User: tsakumar81
Posted: on Feb 05, 2025 03:45 AM
Forum: SQL Server
Answer: 1
Views: 186

I have defined a parameter in sql server stored procedure as @Grade varchar(3) and implemeted validation as

IF len(@Grade)>3
BEGIN 
    SET @ErrMessage = "number of characters cannot be grater than 3" 
END

While executing the stored procedure I pass parameter as @Grade = 'ABCD' but no error message is thrown and 3 characters are inserted into the database.

Please advise how to throw a error message in case if it is more than 3 characters.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Feb 05, 2025 03:54 AM
Report

Hi tsakumar81,

The DataType is specified as VARCHAR having length 3.

So when you pass characters more than 3, automatically it passed 3 characters by skipping all the others.

LEN function always returns 3 or less than 3. It never returns greater than 3.

So in order to validate you need to check the length from code behind and display the error message.

Once success, pass the value having 3 or less than 3 characters to the Stored procedure.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] Validate Length of Parameter using LEN function in SQL Server

Company

Explore

Follow us

Contact Us