SQLServerCentral: Content tagged T-SQL, String Manipulation

LEN()

By Eduardo Rey 2013/03/29 | Category: len()

Rating: (not yet rated) |

Discuss |

Briefcase | 1,863 reads

Silent Truncation of SQL Server Data Inserts

There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs. Read more...

By Additional Articles 2013/02/01 | Source: MSSQLTips.com | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 3,490 reads

STUFF - 2

By bitbucket 2012/12/10 | Category: stuff

Rating: (not yet rated) |

Discuss |

Briefcase | 1,772 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems. Read more...

By Dwain Camps 2012/11/29 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 9,214 reads

STUFF - 1

By bitbucket 2012/11/23 | Category: stuff

Rating: (not yet rated) |

Discuss |

Briefcase | 1,912 reads

Parsing Parameters in a Stored Procedure

This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure. Read more...

By Diego Buendía 2012/11/02 (first published: 2010/08/10) | Source: SQLServerCentral.com | Category: array

Rating:

|

Discuss |

Briefcase | 27,998 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches. Read more...

By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 34,539 reads

Cast in Varchar with different options

By Paresh Patel 2012/07/16 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,926 reads

String Length

By Kenneth Fisher 2012/07/11 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 3,171 reads

T-SQL Integer Data-Type Conversions

This article will show some common integer data-type conversions using T-SQL. Read more...

By Peter Kierstead 2012/06/26 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 6,806 reads

Strings and Defaults

By Gail Shaw 2012/01/26 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,433 reads

Find occurence of any value in database!

Search entire database for occurrence of any text! Read more...

By Reddy Software Solutions 2012/01/09 | Source: SQLServerCentral.com | Category: search

Rating:

|

Discuss |

Briefcase | 4,702 reads

Function to Expand Tab Characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended. Read more...

By Phil Factor 2011/09/29 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,017 reads

Retrieve numbers from a string

This function will take a string parameter and find all numbers in it. Read more...

By Boyd Tyrrell 2011/07/20 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 2,735 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this. Read more...

By Carl P. Anderson 2011/03/04 (first published: 2009/10/14) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 146,961 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches. Read more...

By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 34,539 reads

String tokenizing / splitting

We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend. Read more...

By Irfan Baig 2011/02/25 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 1,764 reads

SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user. Read more...

By Bharat Panthee 2010/12/23 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,301 reads

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports. Read more...

By Richard Doering 2010/12/20 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,820 reads

Hidden Formatting Troubles with STR() (SQL Spackle)

Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it. Read more...

By Jeff Moden 2010/12/15 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 6,324 reads

Content with tags T-SQL, String Manipulation