Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
in dynamic sql removing leading zeros
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
vijay reddy
8y
267
1
Reply
Hi,
i have
select id, name, address from emp. in that id value is comming from other source like '00123' value.
i want to remove leading zeros in dynamic sql query. how can i procede.
id data type is varchar(8). once if i remove the leading zeros.
at run time my data like 'AB123', how can i find the value like.
thanks
vijay
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
i want to get only those records who have only like this
what is cross join in sql server