What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 5636 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
If the string has the space before the like
select LEN(' raj')
select dataLENgth(' raj')
Both consider the space.
but space is after the string len is not bother about space it wil be trucated.
datalenth counted with space.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What programming language would you use to create embedded functions in ssrs?
What are the disadvantages of indexes?
What is the maximum rows in sql server table?
How to drop existing views from a database in ms sql server?
In what sequence sql statement is processed?
What is sql server management studio? : sql server management studio
Differentiate between SQL and ORACLE joins and write their syntax.
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is application role in sql server database security? : sql server security
What is isnull() operator?
Which Model uses the SET concept
Define Business Edition in SQL Azure?
How do I find the default sql server instance?
What is transaction server consistency?
Can a table be created inside a trigger?
