Some time data table contains some records with with spaces in starting, if you trying to get all those records of that then you can use bellow mentioned queries.
1) SELECT * FROM table_name WHERE column_name LIKE ' %'
2) SELECT COUNT(*) FROM table_name WHERE PATINDEX(' %', column_name)>0
Subscribe to:
Post Comments (Atom)
Split the String values with a special character in MS Flow to convert this into Array
Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...
-
Sometimes you experienced when you have subgrid in your CRM Form, but when you click the ‘expand’ button to expand the view then it will re...
-
Use the following line of code to create complete workflow activity with two output parameters. 1) Open Visual Studio 2010 ID. 2) Open ...
-
I have a web service that takes a serialize string and saves it. This works fine for "small" files, but once I hit a large siz...
No comments:
Post a Comment